Unicode字符自动替换为最接近的匹配 [英] Unicode characters getting automatically substituted to nearest match

问题描述

Vb6应用程序通过ODBC连接到Sql服务器，对于某些用户，存储在数据库中的Unicode字符，其中包含å，ä，öchars。

当一个查询被触发时获取此列值，它们被替换为

a，a，o ..而对于其他位置的其他用户，它工作正常他们没有得到转变。



设置了可能的ODBC配置设置：翻译字符数据：是



任何原因可以配置自动转换。我尝试更改客户端Locale，但它没有转换字符..我希望字符不被转换。

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.

推荐答案

当有一个问题时会出现这种问题SQL Server和客户端使用的代码页之间不匹配..



可以找到更详细的文章这里



并尝试从c：\ Windows中禁用自动ANSI到OEM转换 DB-Library选项下的\system32 \cliconfg.exe。

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.

这篇关于Unicode字符自动替换为最接近的匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！