Forums Register Login

execute insert statements having unicode data from java

+Pie Number of slices to send: Send
Hi,

I am facing problems in inserting unicode data into sql server 2005 from a java file. I have written couple of insert statements in file xyz.sql having some unicode data (chinese characters) and saved it as UTF-8.



I have pre-appended capital N to the Chinese characters.

Now when I execute the sql file from java program , Some junk data is being inserted into the database, and yes, the database is unicode compatible.

The java program is ecexuting the insert statements fine but junk data is being inserted into the couloumn where i am expecting chinese data.

If i execute the particular insert statement in sql server ,chinese is being inserted in the couloumns.

can you please help ?

Thanks,
Srikanth
Barry's not gonna like this. Barry's not gonna like this one bit. What is Barry's deal with tiny ads?
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 2291 times.
Similar Threads
Inserting Japanese text into Oracle database
DB2 700 and 701 - Test Sample
store unicode
String, UTF-8, Unicode and DB
db2 - 703 certification
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 01:15:14.