我用的是：php5.2.6 mysql5.0.51b
以下是我mysql的編碼設定
| Variable_name | Value
| character_set_client | utf8
| character_set_connection | utf8
| character_set_database | utf8
| character_set_filesystem | binary
| character_set_results | utf8
| character_set_server | utf8
| character_set_system | utf8
| character_sets_dir | C:\Program Files\MySQL\MySQL Server
5.0\share\chars
ets\ |
整個database都設成utf8
create database buybuy character set utf8;
幾個用中文的欄位也設了
class char(12) CHARACTER SET utf8 COLLATE utf8_general_ci not null,
title varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci not null,
introduce text CHARACTER SET utf8 COLLATE utf8_general_ci not null,
load的檔案也是utf8
網頁顯示也調成了utf8
但是從資料庫讀出的中文就是????
直接echo的中文就能正常顯示
請問還有哪裡沒改到??
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.114.123.134