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