my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes Problem with DB2 & Unicode !!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem with DB2 & Unicode !!!" Watch "Problem with DB2 & Unicode !!!" New topic

Problem with DB2 & Unicode !!!

Kevin Onik
Ranch Hand

Joined: Sep 10, 2003
Posts: 30
Hi friends.
I use DB2 v.7 on IBM Mainframe with )S/390 on it.
the problem is, our App must read & write Unicode characters to DB
( mostly Persian - Arabic ) but simply ... I can't do it !?
I had this problem with MYSQL too but I solved it with a this parameters in the Connection string ---> useUnicode=true&characterEncoding=utf-8 <--
con = DriverManager.getConnection("jdbc:mysql://localhost/MyDB?user=MyName&password=MyPassword&useUnicode=true&characterEncoding=utf-8");

I'm using standard JDBC comes with DB2 that is :
Is there any way like I mentioned above? (about MYSQL)
any suggestions?
Thank you

"The greatest pleasure in life is doing what people say you cannot do." --Walter Bagehot<p>SCJP 1.4<br />SCWCD 1.3</p>
I agree. Here's the link:
subject: Problem with DB2 & Unicode !!!
It's not a secret anymore!