Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Reg: Encoding the european character data

 
arup majumder
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to make a java jdbc code to transfer tables from sql server to Netezza. But as sql server tables having European characters so I cannot load the tables. I tried with java -Dfile.encoding=ISO-8859-15 -jar program.jar . But it didn't work. Can any body help me in it.
 
Deepak Bala
Bartender
Posts: 6663
5
Firefox Browser Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is the character encoding used by your JDBC driver to read strings ? Have you tried setting the characterEncoding property ?

http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html
 
arup majumder
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually my sqlserver tables have Chinese and Japanese charracters. Because of which I am getting error. I am using sqljdbc4.jar and nzjdbc.jar as jdbc driver. Can you tell me how to set characterEncoding property. Or how to Encode Chinese characters.
 
Deepak Bala
Bartender
Posts: 6663
5
Firefox Browser Linux MyEclipse IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did you go through the link I provided in the previous post ? It contains a reference to a property that can be set on the driver. Properties are usually provided on the JDBC connection string
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic