Re: Euro Symbol

"FiberAvenue News Server" <Renee_Petris_at_yahoo.com> wrote in message news:af0vl7$h3c$1_at_brokaw.wa.com...
> 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 ?
> >
>
>

The euro symbol is in WE8ISO8859P15 and MSWIN1252. Your system has to support code page 1252 or to be prepared otherwise. There is a note on Metalink homepage regarding Euro issues.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address