aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC :: Fail to convert between UTF8 and UCS2" Watch "JDBC :: Fail to convert between UTF8 and UCS2" New topic
Author

JDBC :: Fail to convert between UTF8 and UCS2

Chandrashekar B S
Greenhorn

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
Marshal

Joined: Jan 10, 2002
Posts: 61662
    
  67

"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.
Thanks!
bear
Forum Bartender


[Asking smart questions] [Bear's FrontMan] [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.
thanx
Mike

[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="http://sweeps.sitesell.com/minirich.html" target="_blank" rel="nofollow">http://sweeps.sitesell.com/minirich.html</a>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC :: Fail to convert between UTF8 and UCS2