Hello,

at the moment it is impossible for me to write or read euro characters to a database using a jdbc thin driver.

I am using
ojdbc14.jar (version 10.2.0.3.0) and orai18n.jar (also) together with JDK 1.4.2.

Charset of the database is WE8MSWIN1252. It does not work on ORACLE 9.2.0.1, 9.2.0.6 and 10.2.0.2.0 (others I have not tried). But the problem seams to be in thin client.

Inserting Eurosymbols using a PreparedStatement works quite well. Using a normal Statement does not work.
Also the values getting from a ResultSet are incorrect.

After several test I downloaded a patch 4659157 for ojdbc14.jar and 5470375 for orai18n.jar. After installing the patch the euro characters were returned, but:
In several selects of numeric fields (not all, seams to be random) my resultset returned the Euro character instead of 0 and so on.

Driver for 9.2 works quite well, but does not support 10g Release 2 (and contains also some funny bugs)

Following solutions are not suitable for us:
Changing the character set of the database (come on, this cannot be serious. I cannot change the character set of more than 100 databases)
Using the newest driver (ORACLE 11). We are still using JAVA 1.4.2 and cannot migrate our application at the moment.
Using an oci client. Not possible, no ORACLE client on clients...

Has anyone an idea how to deal with this?
Does anyone know when ORACLE is going to release a new jdbc driver for JAVA 1.4.2 (maybe 10.2.0.4.) ??

Regards,

Christian

Hello,

the query returns
Typ=1 Len=1: ac

Regards,

Christian

When inserting data from an oci-client I get
Typ=1 Len=1: 80

€€But character is not displayed correctly. Are you using a thin client? What is the charset of your db? WE8MSWIN1252?

I know the correct form and it is clear to me that the inserted data is already wrong.

The font and the client charset seams to be correct. When I am using the same preferences (font and charset) with ORACLE 9.2 THIN driver I get a correct result.

The OCI driver works well, only the thin driver seams to have some problems.

Just installed PATCH 4659157 and 5470375 from metalink. The Euro problem seams to be corrected.

BUT:
Another problem occurred. Sometimes numeric values are returned wrong (0 from a numeric field comes as euro, 1 comes as Á (2 and 3 too).

This error seams to be random to me.

Our application is selecting a rowid from a table and after that fills several textfields in a frame by selecting the content in a way like this:

select column1 from table where rowid=rowid
select column2 from table where rowid=rowid
...

if I select the numeric column with select nr. 77 I get a wrong value. If I select it at nr. 10 I get the correct value.

The selects are done by a normal Statement object creating a ResultSet. The Value from the ResultSet is fetched by getObject() method.

I also tried to write a test program executing only the selects of the application, but it gives me correct results.
Also when selecting all the fields in one select I get a correct result.

Using a different charset than WE8MSWIN1252 seams to give correct results. Using the OCI driver returns correct results.

Using ojdbc14.jar and orai18n.jar Release 10.2.0.3. unpatched produces the same error (and does not return Euro symbols)

Using ojdbc14.jar and orai18n.jar Release 10.2.0.2. returns correct results (but wrong Euro)

Has anyone had the same problem yet?

Regards,

Christian

Please have a look to Note 365874.1 on Metalink. You seems facing bug 5158739, which requires JDBC Driver 10.2.0.3.0 to be patched (apply patches 4659157 for ojdbc14.jar and 5470375 for orai18n.jar)