作者takeya (心理游戏)
看板Database
标题[SQL ] 有关资料库的编码问题
时间Sun Feb 12 20:53:18 2012
===========================================
旧主机
===========================================
SHOW CREATE DATABASE XXXdbase;
Database Create Database
XXXdbase CREATE DATABASE `XXXdbase` /*!40100 DEFAULT CHARACTER SET utf8 */
SHOW VARIABLES LIKE 'character\_set\_%'
Variable_name Value
character_set_client latin1
character_set_connection latin1
character_set_database utf8
character_set_filesystem binary
character_set_results latin1
character_set_server utf8
character_set_system utf8
原本内容就是乱码,但是网页输出是正常的(utf8)
但将它汇出之後汇入新主机网页和资料库都是乱码
===========================================
新主机
===========================================
SHOW CREATE DATABASE XXXdbase;
Database Create Database
xxxdbase CREATE DATABASE `xxxdbase` /*!40100 DEFAULT CHARACTER SET utf8 */
SHOW VARIABLES LIKE 'character\_set\_%'
Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
上网找了很多方式都不能，请问我该如何作才能正确显示编码 谢谢
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 114.42.136.244
※ 编辑: takeya 来自: 114.42.136.244 (02/12 20:54)
1F：→ hukhuk:MySQL？ 02/12 21:18
2F：→ takeya:是的~sorry没说清楚... 02/13 09:02
3F：→ takeya:问题解决，只要在旧主机上将phpmyadmin的语系别选big5就OK 02/13 11:06