>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...?!

Aaron,
Check collations in MSSQL and sys(987) in VFP.
Cetin