Police Error When Exporting

[Philippe85]

I just upgrade from an old 5.x to a 6.05.

When i export rows in SQL format i have strange caractère for french accentuation.

By example :

Code:

/* SQLyog Community Edition- MySQL GUI
Host – 5.0.18-nt
*********************************************************************
Server version : 5.0.18-nt
*/
/*!40101 SET NAMES utf8 */;

insert into `table` (`LIB`) values('résine');

And i expect

Code:

insert into `table` (`LIB`) values('résine');

Mistake probably or bug, could you help me for where i could search ?

Thanks for help

[peterlaursen]

1) In what program do you open/view the file? Windows version? SQLyog 6 uses utf8 encoding for such files. If the program where you open it does not support utf8 accented characters will display as sequences of two characters. Using utf8 is the only way to ensure portability across platforms and LOCALES. Also the 'mysqldump' program does the same.

You may attach a sample DUMP file here (please zip it!) and we will study the file!

2) try this:

– export a table

– rename the original table

– import to the original table name

isn't it OK after import?

[Philippe85]

I do all you write, and so, i have understood my problem and the mistake.

I use multiple tools for my users, and opening script in editor. When opening in, the UTF8 seem to disappear (Automatic conversion ?), and at the next import the data are corrupted. Now i activate an option for UTF8 in the editor, so copy/paste works fine.

In the past i have not this problem, and dont know why. Could you add in the comment of the export, something to tell that script is in UTF8.

Thanks a lot for all.

[peterlaursen]

Yes if you open in an editor that does not support uft8, saving the file will garble the content.

Before SQLyog 6 the files were ANSI-encoded, from version 6 they are utf8 encoded!

[Author]

Posts