Dear all,

I have a table with TEXT field in MySQL database. The encoding is UTF8. All Chinese characters are display in ??? but for the varchar field all chinese are display ok.

Anyone know what happen? is it the mysql TEXT data type problem ? URGENT get help.

Thanks a lot.

這個問題應該不難，您所指的中文字不知道是Big5還GB，我以Big5為例:

1.如果是DBExpress，只要在SQLConnection1.Params.Values['ServerCharSet']:='BIG5';即可.
2.其他的第三方控件，只要使用類似指令
zquery1.SQL.Text:='Set Names big5';
zquery1.ExecSQL;

依照我的經驗，中文字絕對不會出現問號。