Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to use latin-5 or charset=iso-8859-9 with CA
Message
De
07/07/2006 04:07:40
Aaron K. Y. Chu
Health & Care Co. Ltd.
Hong Kong, Hong Kong
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01133900
Message ID:
01134371
Vues:
21
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!

********************************************************
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform