[Nektarios]

peterlaursen wrote on Nov 14 2007, 06:40 PM:

Please always tell the SQLyog version and the MySQL server version!

Full/exact versions, please!

It is not possible to reply to this question without that information!

Bu as I understand you write greek encoding to datbase tables defined as latin1!? Why do you store greek data in tables defined with latin1 charset (if that is what you do)? With SQLyog 6.1x you can easily define 'iso-8859-7' as database and/or table default! What is the column-level charset setting for strings? If also colums are defined as latin 1 but you store anotehr encoding neitehr the server nor the client will know how to handle those data!

Please refer to: http://webyog.com/faq/content/34/152/en/my…-in-sqlyog.html

One more thing you should know is that you shall never SET NAMES yourself when connected with SQLyog 6.0.

Please refer to: http://webyog.com/faq/content/34/148/en/do…y-language.html

Thanks for your reply.

Versions:

Mysql 5.0.45-community-nt

SQLyog community v6.13

I had v.604 and installed 6.13 now but I cannot find anywhere where I can change the default encoding for database/tables, can you help me out please?

Thanks.

[Author]

Posts