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 DesignThe 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 ConnectStringBy 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!
********************************************************