Greek Encoding In Result Set Problems

[Nektarios]

Hello,

• My db in mysql is latin1 as are the tables.
• My data in the tables are stored as iso-8859-7 encoding.

I can type greek in the editor to make a query, but the result set returns a utf8 encoding of the (iso-8859-7 encoded) data, which are displayed like garbage. I do not want to use UTF8 in my database.

Is there a solution for this?

Thanks.

[peterlaursen]

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

[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.

[peterlaursen]

1) To change the default for a table do ALTER TABLE .. advanced and select the charset and collation

2) To change the default for a database (once it is created) you will have to execute the SQL like

Code:

ALTER DATABASE charset ;

A GUI option in the database menu will be added soon!

NOTE: defaults will only have effect on new 'lower-level' objects added after that! Existing 'lower-level' objects will keep their old defaults.

3) To change the encoding of existing columns that are still empty just change the charset for every string column in ALTER TABLE

4) To change the encoding of existing columns with data you will have to do as described here

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

Quote:

… what you need to do is to perform changes using ALTER TABLE in two operations like:

varchar >> varbinary (or BLO:cool: >> varchar (and similar for char and TEXT types).

This you will have to do on every exisiting string column in every table.

[Author]

Posts