Re[3]: [PHP] utf-8 in mysql but not outputting as utf-8 on web

From: Date: Fri, 23 Dec 2005 03:31:18 +0000
Subject: Re[3]: [PHP] utf-8 in mysql but not outputting as utf-8 on web
References: 1 2 3  Groups: php.general 
Request: Send a blank email to php-general+get-227830@lists.php.net to get a copy of this message
Hello Jonathan, You probably don't have php5 compiled with mbstrings enabled, if you have complied php5 with iconv instead you can try iconv('utf-8' , 'html', $string); I don't know what to recommend if you don't have any of these complied into php5. Best regards, Kenneth -- jonathan wrote:
thanks, never used this function. the weird thing is that it's throwing a fatal error saying mb_convert_encoding is undefined. I'm running 5.0.4. hmmmm..... Fatal error: Call to undefined function: mb_convert_encoding() in / home/arclocal/public_html/preview/Inc/menu.class.php on line 1563 On Dec 22, 2005, at 7:08 PM, Kenneth Andresen wrote:
Hello, why not simply convert the text to html mb_convert_encoding($string, 'html', 'utf-8'); Best regards, Kenneth jonathan wrote:
I'm inserting some info into a mysql table which has the charset set to utf-8. When I do a select via the command-line from mysql, it looks like this: Clams and mussels with Dijon-crème fraîche-saffron sauce assuming this is coming out in your email client ok, it should look good. On a web page, I set the charset to utf-8 via: header("Content-type: text/html; encoding: UTF-8"); as the top-line I then do a select for this field and it outputs like this in the browser: Clams and mussels with Dijon-crème fraîche-saffron sauce I'm familiar with html encoding. As this is going to go to XML, I wanted to see if I could keep it in the native format. Am I doing something wrong on the web side why I won't display this correctly? Is there some Apache config I need to be aware of? thanks, jonathan


« previous php.general (#227830) next »