Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

insert unicode (utf-8:Chinese Characters) values into sql server 2000 db from web form (jsp) Expand / Collapse
Author
Message
Posted Tuesday, June 24, 2008 1:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, April 22, 2012 7:07 PM
Points: 1, Visits: 17
hi, anyone has experience in storing utf-8 unicode(chinese characters) into sql server 2000 database from a web application?

i understand that sql server 2000 only support ucs-2 encoding. how can i stored my origin utf-8 characters into ucs-2 encoding in sql server 2000?

when i type the insert into query directly into the database, it can successfully insert the chinese characters, but when i try to update the data by sending the input from a jsp page, it stored the chinese characters as '𘚟' format instead of converted into ucs-2 codes.

pls help me. thank you.
Post #522363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse