Posted by Francois Bonzon on 06/20/06 19:26

On 2006-06-20 20:55:10 +0200, "Jake" <offsky@gmail.com> said:

> I am trying to allow accented characters (ä, ü ö, ß) to be entered
> into a mysql table. When I use a statement like
>
> INSERT INTO mytable(stuff) values('ä, ü ö, ß3');
>
> I get a row that looks like this: "ä, ü ö, ß3"
>
> I have the table and the column set to "utf8_general_ci" encoding and I
> am using PHP 4. All I am doing is taking the posted values from a form
> and using mysql_real_escape_string to construct the statement listed
> above. Is there some other type of encoding that I need to do before
> submiting the mysql statement?
>
> BTW, If I do that exact statement on the command line of mysql, it
> works, so it is something happening between PHP and mysql.
> Thanks!

Did you try to utf8_encode() your variables? This is a PHP function
from the XML extension.

[Back to original message]