I am getting the following error from Toad for MySQL 6.3.0.642: Lookup Error - MySQL Database Error: Incorrect string value: '\xB7????' for column 'name' at row 1
The insert is the following code (note the Japanese string in column 3):
insert into foo ( content_id, language_id, name ) values ( 1, 75, N'シークレット・ガーデン' ); And here's the table definition:
create table foo ( content_id int not null, language_id int not null, name nvarchar( 255 ) not null ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
The same code works fine from MySQL workbench...any ideas what the issue might be?
Searching online leads to all sorts of MySQL information but again, it seems to be an issue with Toad and not MySQL.
For the record, the above insert works fine when the language is in Korean.
Thanks
|