Codepage - SQL Server Forums

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.

All Forums

Old Forums

CLOSED - General SQL Server

Codepage

Author

Topic

azbatuk
Starting Member

19 Posts

Posted - 2002-04-30 : 13:00:37

Hi,

I am entering some data in Turkish into the SQL server. Turkish and English alphabatical character sets are mostly the same except a few letters. When I retrieve this data within ASP pages, SQL server is (I believe SQL server is doing this)converting those few different caracters to English counterparts.

Server: SQL2000 Trial
Server Collation: SQL_Latin1_General_CP1_CI_AS (I also tried Turkish collation, it didn't differ.)
Database Collation: Default
Field Type: nchar

Does anybody know why this happens ?
Thanks

-------------------
Learning is Living

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-04-30 : 14:47:32

I think it's a problem with the ASP settings:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14953

Changing the ASP page's Response.Charset settings should get it to display correctly.

azbatuk
Starting Member

19 Posts

Posted - 2002-04-30 : 15:39:20

Robvolk,

You were right. It is with ASP.
It's about displaying Unicode characters within ASP pages.
One solution is using "Server.HTMLEncode()"

A better solution is putting codepage="CodePageNo" at the top of the page;

<%@ Language="VBscript" CodePage=28599%>

Thanks

-------------------
Learning is Living

Edited by - azbatuk on 04/30/2002 16:43:58

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources