Forums » General Discussion

Thread: "Incorrect string value" Error for Japanese String Insert

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 0 - Pages: 1 Threads: [ Previous | Next ]
francesco

Posts: 1
Registered: 7/23/12
"Incorrect string value" Error for Japanese String Insert
Posted: Jul 23, 2012 12:24 PM
 
  Click to reply to this thread Reply

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




Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums