How to update Microsoft SQL Server data for different language?

[pctest]

I have a text file which has some ASCII extended characters such as ˜?~¡ÅÂÃ͹Ãv™Æ¼È¶|oœ¼Â¬¾¸tg‰†d|vztxj]. I want to update it to a non-Unicode column in SQL Server and then read it back. If the Windows locale is English, I have no problem. But if the Windows locale is something like Chinese (HONG KONG S.A.R.), the returned value through ODBC is not the right characters. If I select the column in Query Analyzer, it returns the correct characters.

What do I need to change so the returned value through ODBC will return the original characters such as ˜?~¡ÅÂÃ͹Ãv™Æ¼È¶|oœ¼Â¬¾¸tg‰†d|vztxj]?

Thank you for any help.

 

[keithchansc]

pctest

If you are connecting to SQL through ODBC Data Source, try uncheck the 'Perform translation for character data' option

Keith