Incorrect string value

[Techissue2008]

Hi

I set DB, table, column all things are utf8 in mysql 5.0

I use phpmyadmin to insert chinese data and it works

however, when i use php script to insert it, it showed the error:

Incorrect string value: '\xA4@\xBD\xFA' for column 'name' at row 1

I set names utf8 before insert query.

Any idea?

[mwasif]

See if this is not the problem with you http://forums.mysql.com/read.php?103,154519,154613#msg-154613

[Jack_McSlay]

did you make sure the input text is input in UTF-8 as well? Looks like to me you're inputting ISO-8859-1