This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes Special Character Issues in Java with Sybase Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Special Character Issues in Java with Sybase" Watch "Special Character Issues in Java with Sybase" New topic
Author

Special Character Issues in Java with Sybase

Manish Ramrakhiani
Ranch Hand

Joined: Aug 20, 2009
Posts: 44
Whenever trying to insert special charachter(’) from java in sybase getting error. Ascii and Binary value of this special charachter is (’) and 10010010.

Error is as follows-:

Error converting characters into server's character set. Some character(s) could not be converted.


If anyone has any clue ?

Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19684
    
  20

Nope, but I'll be moving this thread to our JDBC forum where we have more database expertise.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

The column may not support that encoding. Check the character encoding for the database/table.


My Blog: Down Home Country Coding with Scott Selikoff
namrata patel
Greenhorn

Joined: Sep 19, 2011
Posts: 1
Manish Ramrakhiani wrote:Whenever trying to insert special charachter(’) from java in sybase getting error. Ascii and Binary value of this special charachter is (’) and 10010010.

Error is as follows-:

Error converting characters into server's character set. Some character(s) could not be converted.


If anyone has any clue ?


Hello Manish, I am facing same exact error. Were you able to find a solution?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Special Character Issues in Java with Sybase