首页 / MYSQL / mysql – 表中的字符集编码
mysql – 表中的字符集编码
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mysql – 表中的字符集编码,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4180字,纯文字阅读大概需要6分钟。
内容图文
![mysql – 表中的字符集编码](/upload/InfoBanner/zyjiaocheng/896/d54981e227414375aca731bad71c3ead.jpg)
我有以下数据:Trollhättan
>如果我打印并将标题设置为utf-8,那么这是浏览器中的输出.
>如果我没有在标题中设置utf-8,Trollhättan.但是,当我将数据存储在数据库中并通过phpmyadmin检查时,我得到以下字符串:TrollhÃ?¤ttan.
>当我设置标题为utf-8时,我得到了这个字符串:Trollhättan旁边的Trollhättan.
由于该表是latin1_swedish_ci,我是否必须在表UTF-8中使用?
解决方法:
以下是UTF-8下的排序规则列表
mysql> select * from information_schema.collations where CHARACTER_SET_NAME = 'utf8';
+--------------------+--------------------+-----+------------+-------------+---------+
| COLLATION_NAME | CHARACTER_SET_NAME | ID | IS_DEFAULT | IS_COMPILED | SORTLEN |
+--------------------+--------------------+-----+------------+-------------+---------+
| utf8_general_ci | utf8 | 33 | Yes | Yes | 1 |
| utf8_bin | utf8 | 83 | | Yes | 1 |
| utf8_unicode_ci | utf8 | 192 | | Yes | 8 |
| utf8_icelandic_ci | utf8 | 193 | | Yes | 8 |
| utf8_latvian_ci | utf8 | 194 | | Yes | 8 |
| utf8_romanian_ci | utf8 | 195 | | Yes | 8 |
| utf8_slovenian_ci | utf8 | 196 | | Yes | 8 |
| utf8_polish_ci | utf8 | 197 | | Yes | 8 |
| utf8_estonian_ci | utf8 | 198 | | Yes | 8 |
| utf8_spanish_ci | utf8 | 199 | | Yes | 8 |
| utf8_swedish_ci | utf8 | 200 | | Yes | 8 |
| utf8_turkish_ci | utf8 | 201 | | Yes | 8 |
| utf8_czech_ci | utf8 | 202 | | Yes | 8 |
| utf8_danish_ci | utf8 | 203 | | Yes | 8 |
| utf8_lithuanian_ci | utf8 | 204 | | Yes | 8 |
| utf8_slovak_ci | utf8 | 205 | | Yes | 8 |
| utf8_spanish2_ci | utf8 | 206 | | Yes | 8 |
| utf8_roman_ci | utf8 | 207 | | Yes | 8 |
| utf8_persian_ci | utf8 | 208 | | Yes | 8 |
| utf8_esperanto_ci | utf8 | 209 | | Yes | 8 |
| utf8_hungarian_ci | utf8 | 210 | | Yes | 8 |
| utf8_sinhala_ci | utf8 | 211 | | Yes | 8 |
+--------------------+--------------------+-----+------------+-------------+---------+
22 rows in set (0.03 sec)
latin1_swedish_ci属于latin1
mysql> select * from information_schema.collations where COLLATION_NAME = 'latin1_swedish_ci';
+-------------------+--------------------+----+------------+-------------+---------+
| COLLATION_NAME | CHARACTER_SET_NAME | ID | IS_DEFAULT | IS_COMPILED | SORTLEN |
+-------------------+--------------------+----+------------+-------------+---------+
| latin1_swedish_ci | latin1 | 8 | Yes | Yes | 1 |
+-------------------+--------------------+----+------------+-------------+---------+
1 row in set (0.03 sec)
排序规则最接近的utf8是ID 200
mysql> select * from information_schema.collations where ID = 200;
+-----------------+--------------------+-----+------------+-------------+---------+
| COLLATION_NAME | CHARACTER_SET_NAME | ID | IS_DEFAULT | IS_COMPILED | SORTLEN |
+-----------------+--------------------+-----+------------+-------------+---------+
| utf8_swedish_ci | utf8 | 200 | | Yes | 8 |
+-----------------+--------------------+-----+------------+-------------+---------+
1 row in set (0.00 sec)
警告
您可能需要尝试使用latin1,更改表中单个列的字符集和排序规则,或者两者都可能.至少,使用latin1在phpmyadmin中显示.
您可以调整并尝试使用ALTER DATABASE将整个数据库设置为特定字符集和排序规则.
ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;
确保备份数据库并将其加载到dev / staging DB中,然后针对dev / staging运行ALTER DATABASE.
内容总结
以上是互联网集市为您收集整理的mysql – 表中的字符集编码全部内容,希望文章能够帮你解决mysql – 表中的字符集编码所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。