Character Set Issues

Hi All,

I have the following issue and would appreciate any advice on what to do to resolve it:

When I enter the € Euro symbol into the database in a SQL statement, I can retrieve it through SQL or the Java front end and see it as a € Euro symbol.

If I enter the € symbol into the database through the java front end, the java front end can retrieve it as a € Euro symbol, but SQL retrieves it as an inverted question mark, which is a problem.

I have tried using the oracle function ASCII() to retrieve the value for the character, the value retrieved is different depending on whether the € Euro symbol was entered using SQL or the Java front end.

The current nls_characterset parameter is AL32UTF8. I'm aware Oracle recommends that 10g databases use UNICODE to cope with all characters. Would this fix the problem? Is there any easier way?

Giles Received on Mon Nov 27 2006 - 09:39:15 CST