I am uploading a XML file which has some special quotes in one of the element like (quotes from MS Word, some other characters cut and paste from Word ---- like this text ABCs purchase of 11, As a result of this payment, the facilitys ownership. )
Please look at the apostrophe after ABC and facility.
create table .ABC"(
"Id" numeric(9) identity not null,
"OrgId" numeric(9) null,
"Notes" text null) Of course it has FK constraints etc.
Error in text is below also attached is the screenshot.
select @@identity]; SQL state [ZZZZZ]; error code ; Error converting characters into server's character set. Some character(s) could not be converted. ; nested exception is com.sybase.jdbc3.jdbc.SybS
n: Error converting characters into server's character set. Some character(s) could not be converted. at org.springframework.jdbc.s
I even tried forcing the hibernate to use the character set conversion via the hibernate config file (by specifying UTF-8 and ISO8859_1) but it did not work. I am using jconn3.jar from sybase
jConnect (TM) for JDBC(TM)/6.05(Build 25828)/P/EBF13044/JDK14
>true 1, false 0, yes Y, no N</property>
<!-- Fix for Special Character errors in Sybase-->
Sybase online manual says that in Chapter 10, When Sybbase Aaptive Server encounters a conversion error while sending data to the client, it replaces the bytes of the suspect characters with ASCII question marks (?).
I want to avoid make a change on sybase server side to make it accept unicode characters, as it might effect other applications. Is there a way we can control this through hibernate or only through sybase. Can we control this behaviour via jconn3 sybase JDBC jar.
I am at loss of ideas here to make this insert successfully in to the database. Please let me know of the solution