Thanks Aaron.
I immidiately send a link to this message to my friend Soykan. He has troubles when he use iso-8559-1 charset.



>Dear All,
>
>After a period of struggling, finally, I crack the method to display characters other than English, in fact, I have used all the methods illustrated by the user in Universal Thread, however, it does not succeed.
>
>This is how I can display "BIG5" Character in Visual FoxPro & in MySQL 5.0
>
>Step 1.Specific Character Set in MySQL server (Optional: if you're intended on only 1 language)
>[mysqld]
>character-set-server=big5
>[client]
>default-character-set=big5
>
>Step 2.Table Design
>The column/Field you want to display non-English character, in this case Big5:
>Column Detail: Column CharSet = Big5; Column Collate = Big5_chinese_ci
>
>Step 3.Amend ConnectString
>By adding SET NAMES 'big5'
>

>DRIVER={MySQL ODBC 3.51 Driver};OPTION=0;UID=sa;PWD=heel;PORT=3306;SERVER=mysql.dataserver.com.hk;DATABASE=cst;stmt=SET NAMES 'big5';
>