Re: Character Set Issues

giles.buist_at_lycos.co.uk wrote:
> 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?

What is 'the Java front end'?

Which operating system is the client on?

What is the character set of the database?

Do you have a 10g database?

Do you have a 10g client?

What is the value of the environment variable NLS_LANG on the client?

Which are the two values that the ASCII function returns?

Is the field containing the Euro characters a VARCHAR2, CHAR, NVARCHAR2 or NCHAR field?

Yours,
Laurenz Albe Received on Mon Nov 27 2006 - 10:48:25 CST