Question

在我的Sql表一中,使用拉丁1特性,将案文储存在瓦尔查领域。由于我们的网站现在在更多的国家得到支持,我们需要支持8 UTF。如果我把这些领域改换为UTF8,那么会发生什么情况? 是否保证这样做,还是将数据放在这些领域? 在将实地改为“UTF8”时,我是否需要考虑?

感谢!

Answer 1

MySQL出色地处理了这一问题:

CREATE TEMPORARY TABLE t1 (
  c VARCHAR(10)
) CHARACTER SET ="latin1";

INSERT INTO t1 VALUES ("æøå");
SELECT * FROM t1; #  æøå 

ALTER TABLE t1 CHARACTER SET = "utf8";
SELECT * FROM t1; #  æøå 

DROP TEMPORARY TABLE t1;

EDIT: 并且不存在不能储存为utf-8的微粒特性,因此,你必须获得任何数据。

Answer 2

在数据库方面没有任何问题。我的SQL将在你改变时处理编码之间的数据转换问题。

你们还需要知道,你们在你们的网站上增加了对UTF-8的支持。

For best results, you should make sure that connections to the database are using UTF-8 as the connection character set. You can do this by issuing SET NAMES utf8 when you make the connection.
You need to make sure that your web pages themselves are declared to the browser as encoded in UTF-8, by changing the meta tag.
Security considerations: You should check user input to make sure it is valid UTF-8, to avoid the possibility of cross-site scripting (XSS) attacks

友情链接