Posted by Jake on 06/20/06 18:55

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!

• Next in forum: Re: Accented characters problem
• Prev in forum: Change alternate commas to semi colons...
• Thread view: Accented characters problem

[Reply to this message]