[SQL ] 有關資料庫的編碼問題
===========================================
舊主機
===========================================
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)
→
02/12 21:18, , 1F
02/12 21:18, 1F
→
02/13 09:02, , 2F
02/13 09:02, 2F
→
02/13 11:06, , 3F
02/13 11:06, 3F