My database is using SQL_Latin1_General_CP1_CS_AS. One of the columns in a table contains value like this:


The column is non-Unicode. It is defined with this:

[minfo] [text] COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL.

If I change the Windows option "Language for non-Unicode programs" to language such as Chinese (Hong Kong S.A.R.), when I select that field through ODBC, the returned value is different from the one returned when the language is English (United States). How can I fix this so the returned value is same in both cases?

Basically, I have a text file which contains some text which includes some extended ASCII characters. I want to able to save the content to the column. I want to able to read the data from the column and perform some manipulation on the returned value. The problem is that the returned value using ODBC is different from the one using Query Analyzer. Is it something that I should change on the ODBC System DNS or I should change the column to ntext?

Thank you.