Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: JDBC and ORA-01722: Client config or database codepage?.

Re: JDBC and ORA-01722: Client config or database codepage?.

From: Thomas Morell <tomy_morello_at_hotmail.com>
Date: 7 Nov 2003 05:38:52 -0800
Message-ID: <63ef0d79.0311070538.14454a46@posting.google.com>


Many thanks, Guy. I will try.

"Guy Dallaire" <gd-newsgroups_at_spamex.com> wrote in message news:<tU8qb.996$143.96416_at_news20.bellglobal.com>...
> Look more like a LOCALE problem than a codepage/chaset problem. Look at NLS
> parameters, I'm no JAVA expert. In oracle you chan look at NLS_LANG and/or
> NLS_NUMERIC_CHARACTERS setting. Look at the oracle NLS documentation.
>
> "Thomas Morell" <tomy_morello_at_hotmail.com> a écrit dans le message de
> news:63ef0d79.0311041438.4aae0055_at_posting.google.com...
> > Hello,
> >
> > We are loading some information into a Oracle 9i database; the
> > data inserted has some . as decimal separator, wheter the database has
> > spanish codepage -in which the , is the separator.
> >
> > Because of this, we are getting a ORA-01722 error; to our
> > surprise, when we choose UTF-8 we get the same exact error.
> >
> > How can this be avoided?. We are running Oracle in Windows. Is it
> > enough to change the database character set?. Can it be changed in the
> > JDBC client?.
> >
> > Many thanks.
Received on Fri Nov 07 2003 - 07:38:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US