Oracle JDBC Euro Character
We have an issue with the euro symbol when saving and retrieving it from Oracle 10g using the Oracle 10.2.0.3 JDBC driver. The problem only occurs during a JUnit test running under Linux. Euro symbols returned from the database after saving are completely screwed down. Oracle is configured to use the "WE8MSWIN1252" character set. Could Linux not work with this character set?
source to share
This is not Linux business. This is a known Oracle bug in the jdbc driver recovery code. There is a patch available there, but you need access to Oracle Metalink to download it. Another alternative is to use the OCI driver instead of the thin one. This may or may not be an option for you.
EDIT:
This bug, which existed in driver 10.2.0.3, has been fixed in jdbc driver 10.2.0.4.
source to share
That's quite possible; code page 1252 is Microsoft's own ISO-8859-1 (aka Latin-1) extension and is rarely used on Linux, which tends to use the latter. The euro symbol is not part of latin-1, which is probably why it cannot be displayed correctly on Linux. Can't you use UTF-8? It will work the same on both sides.
source to share