MSSQL Characters not appearing

Question

So, I'm storing Norweigan characters in an MSSQL table, using nvarchar.

One some pages when I pull these back out in ASP, they display fine...

5 tips som kan hjelpe deg med måltidsplanlegging

But on other pages it's displaying as...

5 tips som kan hjelpe deg med mÃ¥ltidsplanlegging

The recordset is made exactly the same way, the files are on the same server, and even on the same site. The only real difference is that where it displays correctly, the rest of the page is in English, but where the rest of the page is in Norweigan it displays with the odd characters.

In the database itself it's actually stored as mÃ¥ltidsplanlegging, but then on some pages displays correctly as måltidsplanlegging.

Can anyone shed some light on why this might be happening?

looks like this is an ASP.NET question. please use tags properly. — FLICKER, May 18 '17 at 17:39
this question about php http://stackoverflow.com/questions/279170/utf-8-all-the-way-through but almost everything could be applied to classic asp — Iłya Bursov, May 18 '17 at 17:42
@Lashane what is the point in posting a PHP link for an Classic ASP encoding problem? There not even remotely similar but there are plenty of Classic ASP questions / answers on the subject. — user692942, May 19 '17 at 07:45
@Lankymart at least 75% of advises from this answer can be applied to classic asp — Iłya Bursov, May 19 '17 at 14:36

score 0 · Answer 1 · answered May 18 '17 at 19:48

0

try adding the following to the top of your page:

Response.CodePage = 65001    
Response.CharSet = "utf-8"

answered May 18 '17 at 19:48

Josh Montgomery

882
5
10

MSSQL Characters not appearing

1 Answers1