Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Display Chinese Text in MS SQL server
Message
From
13/07/2006 08:44:18
Aaron K. Y. Chu
Health & Care Co. Ltd.
Hong Kong, Hong Kong
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Display Chinese Text in MS SQL server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01135990
Message ID:
01135990
Views:
65
Dear All,

The connection string I used to connect the MSSQL server is as follows:
DRIVER=SQL Server;SERVER=myServer;UID=Me;PWD=MyPassword;DATABASE=myDATA;
I just find out recently in mySQL, we can use SET names 'big5' to specify the charset in the server/client connection... is there any similar switch for MSSQL?

Since my problem is the Traditional Chinese stored cannot display correctly in Visual FoxPro's Forms...?!
Best regards,

Aaron Chu

********************************************************

Working with Visual FoxPro is a lot of FUN!

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

Click here to load this message in the networking platform