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 |
|
dimitrisX
Starting Member
7 Posts |
 Posted - 2005-12-13 : 19:05:33
|
Hello to everyone,I am working on an ASP multilingual application. Users can insert, update and view data in multiple languages, but the default language is Greek. So is the Collation of my database in SQL SERVER 2000: GREEK_CI_AS. The columns that should contain text are of type nvarchar.In order for my asp pages to display data correctly I took the following steps:1. On top of every ASP page (except those that contain only function definitions) I inserted the lines:<% @CodePage=65001%><% response.CharSet="utf-8"%> 2. I set the html character set to UTF-8:<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> The problem is that every now and then and without apparent reason, a page reload causes the greek data that I fetch from the server into a Recordset, to display in chinese or japanese characters, or something like that. However, the greek characters that are 'hard-coded' in HTML are shown corectly.The only way to correct this is to close and reopen the page. This is really frustrating as it happens unexpectedly and not too often, but when it does it just won't go. The user has to close and reopen the page.What might be the cause of that? I suspect that it might not directly relate to sql server, but then I have no clue...Thanks. |
|
|
|
|
|
Unicode - Collation Problems