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 Wed Nov 05 2003 - 09:43:21 CST
