Sqlyog And French Characters

[gonterm]

My company is looking to upgrade from an outdated, free version of SQLyog (v5.22a) to the latest commercial version. I've been testing to find issues and something that is causing me a huge headache is that in the old version of SQLyog, a table that has a lot of french characters in strings is displaying them appropriately, while the new version of SQLyog treats them like they don't exist. String like MÉTAG end up looking like MTAG instead.

That table is type latin1 and I tried changing it to utf8 and that didn't help. The most confusing part of it all is that the old version works perfect but the newer version doesn't. Please, any insight would be helpful!

Thanks,

Michael

[Mahesh]

'gonterm' wrote on '25:

My company is looking to upgrade from an outdated, free version of SQLyog (v5.22a) to the latest commercial version. I've been testing to find issues and something that is causing me a huge headache is that in the old version of SQLyog, a table that has a lot of french characters in strings is displaying them appropriately, while the new version of SQLyog treats them like they don't exist. String like MÉTAG end up looking like MTAG instead.

That table is type latin1 and I tried changing it to utf8 and that didn't help. The most confusing part of it all is that the old version works perfect but the newer version doesn't. Please, any insight would be helpful!

Thanks,

Michael

SQLyog is fully UNICODE-compliant since version 6.0.

We tried this case at our end :

CREATE TABLE `test` (

`name` varchar(20) character set utf8 default NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `french_chars`.`test`(`name`) VALUES ( 'MÉTAG');

(See the screenshot attached here with)

Also Please read these FAQ:

http://www.webyog.com/faq/content/34/152/en/my-special-characters-display-as-_noisy_-latin-characters-in-sqlyog.html

http://www.webyog.com/faq/category/34/character-set-and-localization-issues.html

Please tell,

1) Program version you have used ?

2) Can you attach a sample table structure along with sample data, this will be helpful for us to debug a problem?

[gonterm]

Thanks for responding,

We are currently using version 5.22 of SQLyog, looking to upgrade to the newest version. I'm working with the trial version of 8.4. I'm attaching the data structure in question with a bit of sample data that is causing me trouble. I tried the following so far:

1) Alter table and modify the RawTxt column to be varchar(120) character set utf8…

This resulted in an error because it created duplicated records because it dropped the rest of the string once it hit a french character.

2) Creating a new version of the table with varchar(120) for RawTxt and inserting from my old table with the varbinary into the new one…

Same result, it truncated the string once it hit a french character.

Any advice?

[Mahesh]

We are unable to reproduce this issue at our end.

Can you please attach .SQL file having a table structure along with sample data ?

[Author]

Posts