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.
| Author |
Topic |
|
balamurugan
Starting Member
15 Posts |
 Posted - 2005-07-14 : 16:13:24
|
| We are globalizing out website which is created in ASP. I am reading the web page content from the SQL 2000 database Data type : nvarchar Column collation : SQL_Latin1_General_CP1_CI_ASand displaying it on the asp page.It works good for "GERMAN", "FRENCH" and "ITALIAN". I need to do the same thing for RUSSIANKOREANJAPANESECHINESE.I have tried with different collation listed under "window collation" in table design view. It doesn't seem to be working. I am getting all ???????. Can you pl. help me how to resolve this issue? |
|
|
balamurugan
Starting Member
15 Posts |
Posted - 2005-07-22 : 10:55:26
|
| I found the solution for this. Basically we don't need to anything special for languages like japanese,chinese. Data type nvarchar/ntext andField collation :SQL_Latin1_General_CP1_CI_AS works good for all languages. Only thing is we have use the proper code page in META tag in the asp/html page.Example :for Japanese: Session.CodePage = 932<HEAD> <title> Client Feedback Satisfaction Program</title> <meta http-equiv="Content-Type" content="text/html; charset= iso-2022-jp"></HEAD>works pretty good.and collation is same |
 |
|
|
|
|
|
collation