aspose file tools*
The moose likes JDBC 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
Bookmark "Problem with DB2 & Unicode !!!" Watch "Problem with DB2 & Unicode !!!" New topic
Author

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 :
"com.ibm.db2.jcc.DB2Driver"
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>
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Problem with DB2 & Unicode !!!