Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Insert different languages in sql database

Author  Topic 

simondarian
Starting Member

1 Post

Posted - 2008-02-04 : 22:49:51
Hi,
I am creating a new form that allows different languages(ie. Chinese, Japanese) to be inserted into MSSQL 2000 database. However any language other that English alphabet characters are inserted as bunch of number, I guess it would Unicode format. But when I call it into the WebPages they still come and shown as numbers. How can I get them to get converted back to their actual targeted characters of the corresponding language?
I am using asp pages, if in any way would matter!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-02-04 : 22:57:18
You need to set proper COLLATON settings for SQL to understand other languauges. Search in BOL for COLLATIONs available in SQL server.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-04 : 23:19:21
May need encode them in app.
Go to Top of Page
   

- Advertisement -