question

TheBat avatar image
TheBat asked

Using Multiple Languages in SQL

I am storing English, Czech, Turkish and Chinese within the same SQL 2008 Database - field using nvarchar (Latin 1) Depending on where the visitor is from the web page charset is set to iso-8859-1 or utf-8 etc. I am using Classic ASP(also have tried it in ASP.NET) the Response.CodePage is set to 1252. When the data is queried the correct characters are shown on the web page but when saved to text or excel file they are corrupted. Do I have the database correctly set-up to use multiple language in a field.
language
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
robbin avatar image
robbin answered
If you can see it perfectly on the web, then you have setup the database correctly. Are you saving the text file as Unicode? Moreover, the text and excel files would be dependent upon OS and add-ins.
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TheBat avatar image TheBat commented ·
I have tried it using "windows-1252", "utf-8" with an "ADODB.Stream" and "Scripting.FileSystemObject". I have event tried this in ASP.NET using many different methods of converting the characters. What every I do I do not get the characters that were entered by the user.
0 Likes 0 ·
robbin avatar image robbin commented ·
Please read this KB. May it help. http://support.microsoft.com/default.aspx?scid=kb;en-us;893663&sd=rss&spid=6351 You can revert if it does not solve the problem.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.