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-14 : 04:45:32
|
Hello,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. The user has to close and reopen the page. I Can't seem to find a solution.Any help would be appreciatedThank you. |
|
|
activecrypt
Posting Yak Master
165 Posts |
|
|
dimitrisX
Starting Member
7 Posts |
Posted - 2005-12-20 : 03:26:28
|
| didn't solve it but thanks anyway. I think the problem is with the way my browser handles unicode and not sql server. |
 |
|
|
ptalkad
Starting Member
4 Posts |
Posted - 2008-01-17 : 20:34:16
|
| hi, the article link is good for languages, what if I have Maori macrons like a,e,i,o and u to store in the database. I have a ms sql server 2000 db which is not storing the a kind of characters. any help is appreciated.thanks |
|
|
|
ptalkad
Starting Member
4 Posts |
Posted - 2008-01-17 : 20:35:25
|
| whoaaaaaaaaaaaaa!! the text editor had accepted the maori macrons but it was not displayed in the topic !!! SQLTEAM !!! can you please tell us why !!! |
|
|
|
|
|
|
|
|
Unicode - Collation problem in ASP app