Click here to Skip to main content
15,041,025 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Vb6 application is connected to Sql server via ODBC, and for some users, the Unicode Characters which are stored in the database, having å, ä, ö chars in them.
while a query is fired which gets this column values, they are substituted by
a, a, o.. and for some other users in a different location, it works fine and they donot get converted.

Possible ODBC configuration setting is set: "Translate Character Data: Yes"

Any reason where this auto conversion could be configured. I tried changing the client Locale, but it doesnt convert the chars.. I want the chars NOT to be converted.
Updated 18-Jun-13 6:37am
Sergey Alexandrovich Kryukov 18-Jun-13 12:13pm
VB6? You cannot be serious. It cannot not fully support Unicode. I would say, it cannot support programming. Is there any particular reason to suffer from this trash?

1 solution

This kind of problem occurs when there is a mismatch between the code page used by the SQL server and the client..

More detailed article can be found here

and try disabling the Automatic ANSI to OEM conversion from c:\Windows\system32\cliconfg.exe under the DB-Library options.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900