Sybase ASA 8 字符问题 - £ VS ú
我在客户端遇到一个问题，即相同的数据字段在安装在两台不同计算机上的旧应用程序中显示不同。 有问题的字符是英镑符号 £，在某些机器上显示为 ú。
我曾尝试在错误的机器上用 £ 过度键入该字符，但这会在之前正常工作的机器上“破坏”它。
奇怪的是，尽管应用程序多年来没有发生任何变化，但这个问题已经开始蔓延到其他计算机，并且客户向我保证没有对它们应用新的软件或更新。 字段值的显示在所有数据库连接上都是一致的，即。 通过我们的应用程序 Interactive SQL 和 Crystal Reports 8、9 和 10.
所有客户端计算机均通过 ODBC 通过 TCP/IP 连接到同一 ASA 8.0.2.4234 数据库服务器服务。
I have an issue at a client where the same data field displays differently in our legacy application installed on two different machines. The character in question is the UK pound sign £ which on some machines displays as ú.
I have tried to over-type this character with £ on machines where it's wrong, but this then "breaks" it on machines where it was working correctly before.
Oddly this issue has started to spread to other machines even though there has been no changes to the application for several years, and the client assures me that no new software or updates have been applied to them. The displaying of the fields value is consistent on all connections to the database, ie. through our application, Interactive SQL and Crystal Reports 8, 9 & 10.
All client machines are connecting via ODBC to the same ASA 8.0.2.4234 database server service over TCP/IP.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
Sybase ODBC 客户端几乎肯定会使用不同的字符集。 如果不了解更多关于应用程序的信息，就很难知道在哪里获取了错误的字符集，但是您可以在设置 ODBC 数据源时覆盖正在使用的字符集。
The Sybase ODBC clients will almost certainly be using different character sets. Without knowing a bit more about your application it is difficult to know where the wrong character set is being picked up, but you can override the character set in use when you set up the ODBC data source.