Posted by Nickneem on 09/24/06 19:48

I'm having trouble getting the output of a (MS SQL server) query in
html:

± is displayed as &# 177 ;
and -» as - &# 187 ;
not to mention the acute accent (é) and other diacritic characters.

I guess there's a problem with displaying the extended ascii characters
in Internet Explorer, some applications seem to have no problem with it
but if I create an asp.net app or a crystal report I get these strange
characters?

I read something about setting the latin 1 codepage setting:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage\ACP
(1252 on my sql server)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;199819

but I'm not quite sure if this is actually the problem.

I hope some of you guys can help me because it really looks akward on
my reports...

Thanks in advance,

Michael

• Next in forum: reset sa password msde (sql server 7)
• Prev in forum: Re: how to get this resultset...
• Thread view: Problem displaying extended ascii characters from sql server in html

[Reply to this message]