MySQL Forums
Forum List  »  MySQL for Excel

Re: Edit or insert records with Japaneese characters failed
Posted by: Javier Treviño
Date: August 29, 2016 10:34PM

Hi Hamdy,
Are the characters in the generated query:
1: INSERT INTO `Integration`.`CCEJ_B_Base` (`C1_Base`,`C1_Base_Name`,`BO_Base`,`BO_Plant_Text`,`Updater_ID`,`Delition_Flag`,`Updated_Date`) VALUES ('146','列数','列数','列数','列数','列数',null)

the exact characters you see in the Excel Worksheet where you are adding the data?

You said that you compared with MySQL Workbench.
Did you run the exact generated INSERT statement in MySQL Workbench and when running a SELECT you get the correct characters back?

I am interested in knowing if that generated INSERT statement worked with your DB setup.
Normally the problem you are reporting is one related to either:

1. A wrong collation in the table, or if using the default, in its parent schema.
2. A wrong charset specified in the character_set_client or character_set_connection system variables. Are these set to a character set that supports chinese/japanese characters?

Best regards.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Edit or insert records with Japaneese characters failed
905
August 29, 2016 10:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.