Re: Euro Symbol

What is the character set of your database? If the Euro Symbol is being converted to a "?", it generally means that it isn't a valid character in the database character set. You can determine the character set of you database by doing a select * from nls_database_parameters in sqlplus. When inserting into a varchar2, the character set for NLS_CHARACTERSET needs to contain the Euro Symbol, or you'll get a "?". For example my database has NLS_CHARACTERSET=WE8ISO8859P1. Varchar2 fields can't hold the euro symbol since it isn't a member of the 8859-1 character set.

An nvarchar2 can have a different character set than a varchar2. Look at the values in nls_database_parameters for NLS_NCHAR_CHARACTERSET. If that exists, its value is the character set for nvarchar2 columns. How an nvarchar2 works depends on the version of Oracle. In 8i, the nvarchar2 character set had to be a superset of the varchar2 character set. In Oracle 9i, it can only be UTF8 or AL16UTF16.

"Fred Burlaud" <fburlaud_at_com6.fr> wrote in message news:3D10B57B.9060101_at_com6.fr...
> Hello,
>
> Using jdbc, I would like to insert the Euro Symbol in a field.
>
> With a varchar2 type, It seems that Hexa value of the symbol is correct
>
> But when I read it, I don't get the Euro Symbol but "?"
>
> Is that the ascii conversion bad ??
>
> How can I resolve my pb ?
>
> Thanks
> Fred
>
> PS.
>
> What's the difference between nvarchar2 and varchar2 type ?
>
Received on Fri Jun 21 2002 - 23:49:25 CDT