Oracle JDBC欧元字符 [英] Oracle JDBC Euro character

问题描述

在使用Oracle 10.2.0.3 JDBC驱动程序从Oracle 10g中保存和检索欧元字符时，我们遇到了一个问题。该问题只发生在Linux下运行的JUnit测试期间。保存后从数据库返回的欧元字符完全拧紧。 Oracle已配置为使用字符集WE8MSWIN1252。是不是Linux不能使用这个字符集？

We have a problem with the Euro character when saving and retrieving it from a Oracle 10g using the Oracle 10.2.0.3 JDBC driver. The problem only occurs during a JUnit test running under Linux. The Euro characters returned from database after saving are total screwed up. Oracle has been configured to use character set "WE8MSWIN1252". Could it be that Linux cannot work with this character set?

推荐答案

这不是Linux的东西。它是jdbc驱动程序的检索代码中的一个已知的Oracle错误。有一个补丁可用，但您需要访问Oracle Metalink下载它。另一个建议是使用OCI驱动程序而不是瘦驱动程序。

It's not a Linux thing. It's a known Oracle bug in the retrieve code of the jdbc driver. There's a patch available but you'll need access to Oracle Metalink to download it. The other alternative suggested there is to use the OCI driver instead of the thin one. That may or may not be an option for you.

编辑：

此错误存在于10.2.0.3驱动程序，固定在10.2.0.4 jdbc驱动程序中。

This bug, which existed in the 10.2.0.3 driver, is fixed in the 10.2.0.4 jdbc driver.

这篇关于Oracle JDBC欧元字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！