Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to use latin-5 or charset=iso-8859-9 with CA
Message
From
07/07/2006 04:07:40
Aaron K. Y. Chu
Health & Care Co. Ltd.
Hong Kong, Hong Kong
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01133900
Message ID:
01134371
Views:
20
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!

********************************************************
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform