Hi Hi,
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';
Best regards,
Aaron Chu
********************************************************
Working with Visual FoxPro is a lot of FUN!
********************************************************