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

From: Thomas Morell <tomy_morello_at_hotmail.com>
Date: 4 Nov 2003 14:38:29 -0800
Message-ID: <63ef0d79.0311041438.4aae0055@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 Tue Nov 04 2003 - 16:38:29 CST