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 |
|
mcmahonc
Starting Member
2 Posts |
 Posted - 2008-08-15 : 05:02:53
|
| Hi Folks,I am looking for a bit of help with some non-ASCII characters. Apologies if this is a silly question, I am new to SQL server but not new to other databases and I have not had this problem with say MySQL for example. My workplace have been successfully running a MS SQL Server for a number of years. We are now tasked with supporting elements of this database in multiple languages, namely Czech and Slovak. From the research I have done into this we need to maintain nvarchar fields for any corresponding varchar fields so that we can support the non-ASCII characters in these languages. I have created a number of nvarchar fields and also added a Collation of SQL_Czech_1250_AS_CS to them. This has worked fine and within SQL Server I can see that the characters are displaying correctly. If I do a SELECT within SQL Server I am returned the text displaying the correct characters, for example “Cesku i v zahranicí”. If I use ASP to connect to the database and display the same field in a browser the caron’s over the C characters are lost and displayed as “Cesku i v zahranicí” within the browser. As the characters appear to be stored correctly on the database, and can be selected directly on the database why are they being lost when you try to display them inline in a browser? Any ideas?Regards,Claire |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-08-15 : 07:17:01
|
| I am not sure if i can help.Because nobody has answered til now i will try.I think ASP in a browser results in HTML.In HTML it's maybe the problem of encoding charsets.Look at this link, maybe it helps:http://htmlhelp.com/tools/validator/charset.html.enIf it is not helping i am sorry for wasting your time...WebfredToo Old to Rock 'n' Roll, Too Young to Die |
 |
|
|
mcmahonc
Starting Member
2 Posts |
Posted - 2008-08-18 : 07:48:29
|
| Thanks for taking the time to reply, I appreciate it. I had played around with encoding but to no avail. I will read your reference though and perhaps it will inspire me. Have a great day. Regards, Claire |
|
|
|
|
|
|
Problem displaying nvarchar chars with ASP