Found it. Have to use:
mysql_query("SET CHARACTER SET 'utf8'", $link);
""Guus Ellenkamp"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> The document IS UTF-8. The character does not seem to be. It comes from a
> mySQL database. However, also the database settings are also UTF-8. The
> field was entered into the database with phpMyAdmin. I tried it now local
> on my test-system and remote, so the database itself does not seem to be
> the problem. Could it be phpMyAdmin?
>
> "Jon Anderson" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>> Guus Ellenkamp wrote:
>>> I have a string with an n with a tilde. mb_detect_encoding says it's
>>> UTF-8. I set the http encoding to UTF-8 and also the internal encoding.
>>> However, I cannot produce proper output with echo $varwithtilde.
>>>
>>> echo $returnArray[$i]->address1.' has
>>> '.mb_detect_encoding($returnArray[$i]->address1)
>>> does NOT produce correct output in a browser or with the W3C validator,
>>> although it says the encoding of the var is UTF-8.
>>>
>>> What's wrong?
>>>
>> Character set issues can be very complex, but I'm going to take a
>> guess....
>>
>> If you're outputting something that is actually UTF-8, you'll need to
>> make sure that you've done these:
>>
>> header('Content-Type: text/html; charset=utf-8');
>>
>> I believe that IE6 requires this one as well within your html head.
>>
>> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
>>
>> If that doesn't work, then it could be that your character isn't actually
>> UTF-8 encoded.
>>
>> jon
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
