File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC :: Fail to convert between UTF8 and UCS2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC :: Fail to convert between UTF8 and UCS2" Watch "JDBC :: Fail to convert between UTF8 and UCS2" New topic

JDBC :: Fail to convert between UTF8 and UCS2

Chandrashekar B S

Joined: Jan 07, 2004
Posts: 1
I have deployed my J2EE application in Weblogic Server (6.1), I am creating a database connection pool.
My database Oracle 8i supports UTF-8 character set & also has UTF-8 character (Euro Symbol) as data in one of the tables.
When I try to read the symbol from the database, it throws Fail to convert between UTF8 and UCS2
Assuming the case : I can�t get my Weblogic application server down, Can I read this symbol from the database.
While creating the connection pool, I have not mentioned anything about character encoding, hence I think it creates the connection considering the default Operating Systems character encoding.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63870

"Chandrashekar B S",
We're pleased to have you here with us in the JDBC forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Forum Bartender

[Asking smart questions] [About Bear] [Books by Bear]
Mike Nightsky
Ranch Hand

Joined: Aug 18, 2001
Posts: 48
Im also interested in a solution for this problem cause we are working with central/east-european countrys with many special characters and also cyrilic characters in one database.

Im getting the error when i fetch the outparameter from a preparedCall with the data.

[Bear edit: issues with the naming convention should be raised in the JavaRanch forum]
[ August 19, 2004: Message edited by: Bear Bibeault ]

Win the opportunity to make money on the Internet<br /><a href="" target="_blank" rel="nofollow"></a>
I agree. Here's the link:
subject: JDBC :: Fail to convert between UTF8 and UCS2
It's not a secret anymore!