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.