Sqlyog Import Problem

[Corne]

Hi there. I've been using SQLYog 5.02 for quite a while now without any problems.

Recently got the evaluation version of 9.61.

I migrated my DB from MySQL 4.1.22 to 5.1.61 and already went live with the DB because there were no errors detected. However working on the DB for a while now I saw that SQLYog imported certain data with special characters incorrectly. For instance the following lines:

('ENG003','Mnr.','C','Engelbrecht','Cornè'), the name “Cornè” was only imported as “Corn”

('END001','Mnr.',NULL,'Endeman','Hoërskool'), the name “Hoërskool” was imported as “Ho?rskool”

This is huge problem for me now to try and rectify and I must say I'm quite disappointed in the product.

I did some tests by importing on MySQL 4.1.22 and 5.1.61 with SQLYog 5.02 which works fine, the data is imported correctly.(So its not a MySQL problem)

As soon as I use SQLYog 9.61 to do the importing I get the data loss as described above.

[peterlaursen]

The problem is undoubtedly a variant of this one:

http://www.webyog.co…-in-sqlyog.html

.. and as such a problem with thow you store data in your database.

Now please tell:

1) How was the SQL-dump created? With SQLyog 5.x or 9.6x or another application? Does the import job create the tables of did they exist in advance?

2) How is the dump file encoded?If it is UTF8 please open the dump in Notepad or any utf8-enabled editor and check if the accented characters display correctly here?

You are welcome to create a private ticket by sending a mail to support@webyog,com. We wil need to see some sample data/scripts and you may not want to exchange them in public.

[peterlaursen]

We also need the result of “SHOW GLOBAL VARIABLES LIKE '%char%';” from the server.

[peterlaursen]

And finally please read:

http://www.webyog.co…y-language.html

“However if you execute a SQL-script from a file you may include a SET NAMES statement in that file. You will need to do if character data in the file are not encoded with the server default charset. When SQLyog executes an external file, a separate connection is created for that and SET NAMES in that file will not affect the connection that the GUI uses. SQL scripts generated by SQLyog are UTF8-encoded and the file contains a “SET NAMES utf8″ statement. But if the script is generated with another program it is not necessarily the case.”

So does the script/dump contain a SET NAMES statement on top matching how data are encoded in the file?. As far as I remember SQLyog before 6.0 did not add a SET NAMES statement to SQL-dumps and the data in the dump was encoded 'as returned by the server' and the file was ANSI encoded. (unlike from 6.0 where file and data are always UTF8 encoded in SQLyog dumps and there is a SET NAMES UTF8 on top).

Please share a complete table dump with us to [email protected] (you may strip a lot of data as long as only one row is there where the problem is reproducible).

[Author]

Posts