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';