I Can´t Find Default Charset In Connection Manager

[EduPhocus]

I can´t find Default Charset in Connection Manager (http://www.webyog.com/images/screenshots/conn_mngr.jpg)

I have 1 client that use ASCII in your tables.

When I do backup , occurs accentuation problem in text data.

I need that Default Charset appers for choose your connection.

I change chatset connection using other software (MYSQL Front) but plans use SQLYog because your Backup Schedule is great.

Help me please.

P.S. – Sotty, my english is horrible.

[peterlaursen]

Actually this screenshot

Please tell

1)

what is the program version you are using?

If the dropdwon is not there it is either 6.0 or a very old version!

2)

And what is you native language and the language of your Windows installation?

3)

After connection to a database please execute

Quote:

SHOW VARIABLES LIKE '%character%';

and paste the result here

4)

Finally tell the server version

Quote:

SELECT VERSION();

.. will tell you that

related FAQs:

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

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

[EduPhocus]

'peterlaursen' wrote on 'Nov:

Actually this screenshot

Please tell

1)

what is the program version you are using?

If the dropdwon is not there it is either 6.0 or a very old version!

Version 6.11

2)

And what is you native language and the language of your Windows installation?

Brazilian – Portuguese

3)

After connection to a database please execute

and paste the result here

character_set_client utf8

character_set_connection utf8

character_set_database latin1

character_set_results utf8

character_set_server latin1

character_set_system utf8

character_sets_dir /data/mysql/warner/share/mysql/charsets/

4)

Finally tell the server version

.. will tell you that

5.0.18-standard-log

[EduPhocus]

'peterlaursen' wrote on 'Nov:

Actually this screenshot

Please tell

1)

what is the program version you are using?

If the dropdwon is not there it is either 6.0 or a very old version!

Version 6.11

2)

And what is you native language and the language of your Windows installation?

Brazilian – Portuguese

3)

After connection to a database please execute

and paste the result here

character_set_client utf8

character_set_connection utf8

character_set_database latin1

character_set_results utf8

character_set_server latin1

character_set_system utf8

character_sets_dir /data/mysql/warner/share/mysql/charsets/

4)

Finally tell the server version

.. will tell you that

5.0.18-standard-log

[peterlaursen]

With those server adn SQLyog version everything should be handled sully automatic.

An important point is that you shall not SET NAMES or SET CHARACTER _SET_ yourself. The program does what is required!

Please refer to:

http://www.webyog.com/faq/content/34/148/e…y-language.html

Please confirm that you don't!

But I actually think that a very special issue with Portuguese was fixed between 6.11 and 6.12. Please try 6.13 or 6.14 RC!

BTW: also that server should be upgraded! Server bugs are NOT out of question here! What are the data types where you experience this? char/varchar/text/blob? or more of them? I think I recall an issue with TEXTs and early MySQL 5.0 servers!

[Author]

Posts