Thursday 15 May 2014

oracle - Java clob retrieval using getString - character encoding issue -


Then I have a database with the table, where one of these entries is' é € áí ', And I know it's right in DB. It is stored as a clob .

In Java, I retrieve the entry in this way:

  string text = result.sat.getstring (dbcstent COL_NOTE_TEXT);  

While debugging, the text is equivalent to ' é \ u0080áí and the Euro icon is displayed as a square block when displayed on the screen.

Has anyone seen this before? Any suggestions?

Thanks in advance.

0080 Euro characters is Windows Western encoding (CP-1252); This is 20AC in Unicode. You may want to check the encoding of the input. The second thing is that the screen is capable of displaying the euro symbol if it displays '\ u20ac' then that part will be answered.


No comments:

Post a Comment