Danish Characters Issue

[itHighway]

I have a website in Danish.

The problem is some characters are not displaying correctly. Some of the data on my site is hard coded while some data comes from ms access database.

If content type is Utf-8 then hard coded content look okay but data that comes from db starts to show some square boxes in place of some Danish characters.

While if content type is iso-8859-1 db content looks okay but hard coded content show boxes.

I am using Classic ASP with MS Access database.

Please advice.

[samanime]

Try setting the charset of the HTML to match the database, or change the database to be UTF-8.

[itHighway]

Is it possible to change the charset of MS Access database?

[samanime]

Good question. It's been a LONG time since I used Access.

Lol, I googled it and came across you asking the question. From other things I found on Google, it looks like Access uses UTF(-8?).

Do you know if the iso-8859-1 charset has all of the Danish characters you need?

Also, how are you outputting the database content? I've had problems in the past where it wasn't the database that was having issues, but the function I was using to output the code. Double-check your functions and make sure they don't specify a charset anywhere.