Non-English Characters - 1366: Incorrect string value: '\xF9
Posted: Thu Nov 25, 2010 12:19 am
Hello, having some trouble with a PHP script and trying to update or insert into MYSQL database where non-English characters are concerned.
From what I found so far for example, ù and à or any other non-English character result in error in my script (i.e. I've tried them by themselves only):
1366: Incorrect string value: '\xF9'
I can go into the MySQL Workbench and insert ú and these characters fine without this error. Having done that when I try to read it this character becomes 'úA'
What am I doing wrong?
I've tried "mysql_set_charset('utf8');" before executing my query.
Database schema is set to UTF8-Default Collation
Thanks
From what I found so far for example, ù and à or any other non-English character result in error in my script (i.e. I've tried them by themselves only):
1366: Incorrect string value: '\xF9'
I can go into the MySQL Workbench and insert ú and these characters fine without this error. Having done that when I try to read it this character becomes 'úA'
What am I doing wrong?
I've tried "mysql_set_charset('utf8');" before executing my query.
Database schema is set to UTF8-Default Collation
Thanks