Corrupted Display with UTF-8 characters and MSSQL database
I have developed a website for a client that uses an MSSQL database to store the page data. I have done this many times in the past without problem, but for this client, I am not having success.
The english pages render without any problems. But he now has translated his site into hebrew, which we have encoded (hopefully) using UTF-8, and the information is not displaying at all. Instead we see question marks on the screen. As if that wasn't bad enough, we actually sometimes see the information correctly on the screen (perhaps after we rebooted, or something else, but both me and my client have successfully seen the pages rendered correctly without modifying the data or the website at least once).
An example of this can be found here:
http://www.nlpjerusalem.com/index.asp?lang=HE
Along the top row are all the menu choices. The one or two that display in proper hebrew characters are due to the fact that they were entered as ESCape characters (e.g. &# and the the number, such as 1510 and a ;).
I am currently developing in MS Expression Web Designer (beta), but I can't think of how that could have an effect on the information.
I've checked the database, and everything is perfect there. I use an online editor to edit the data, but can also view it in MS Access 2000.
Any ideas how to solve this. I'm going crazy (as is my client) and I can't think of a solution.
Thank you for any solutions you can come up with.
The english pages render without any problems. But he now has translated his site into hebrew, which we have encoded (hopefully) using UTF-8, and the information is not displaying at all. Instead we see question marks on the screen. As if that wasn't bad enough, we actually sometimes see the information correctly on the screen (perhaps after we rebooted, or something else, but both me and my client have successfully seen the pages rendered correctly without modifying the data or the website at least once).
An example of this can be found here:
http://www.nlpjerusalem.com/index.asp?lang=HE
Along the top row are all the menu choices. The one or two that display in proper hebrew characters are due to the fact that they were entered as ESCape characters (e.g. &# and the the number, such as 1510 and a ;).
I am currently developing in MS Expression Web Designer (beta), but I can't think of how that could have an effect on the information.
I've checked the database, and everything is perfect there. I use an online editor to edit the data, but can also view it in MS Access 2000.
Any ideas how to solve this. I'm going crazy (as is my client) and I can't think of a solution.
Thank you for any solutions you can come up with.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
was what was (apparently) needed to correct the situation. I put it on my pages, and then instantly began working. I tried another computer, and I tried in Firefox, and everything is perfect.
Thank you for the quick response! you've saved the day.