Strange character set

[1915]

Hi all.

I get som strange characters when parsing text from my mysql-database. All goes fine with regular text, but swedish characters (åäö,ÅÄÖ) is replaced by characters like these: åäö

I dont know if the problem lies in mysql or php.

Serverinfo:
Apache/2.0.39 (Win32) mod_auth_sspi/0.9.0 PHP/4.2.2
mysql version 3.23.39
Running on Windows XP

The critical code looks like this:

--

$q = "SELECT * FROM artiklar";
$res = mysql_query($q) or die(mysql_error());
while ($row = mysql_fetch_array($res)) {
echo $row['rubrik'];
}

--

And the fieldtype for 'artiklar' is varchar(80).

All help would be appreciated...

[thoand]

I have had the same problem when using the MySQL monitor in Win 32. But It goes fine when I use a HTML form.

Search for stirings etc. in the manual, or
maybe a search for Unicode could help you on the way.

regards Thomas A.

[dzig]

It looks like a problem with the charset utf-8. What charset do you want to use?

example: put

<meta HTTP-EQUIV="Content-Type" CONTENT="text/html"; charset="iso-8859-1">

on the input page and the same on the output page.

-check your browser so it's using ISO charset...

you can also set the default charset in php.ini.

/Patrik