[SOLVED] Toad for MySQL, how to make friends with Cyrillic?

Question

MySQL

I haven't picked up checkers for a long time...

On a Windows 7 machine, there is MySQL server 5.5, a database with tables in utf8_unicode_ci, and Toad for MySQL 6.0.1.

When executing queries with the insertion of Cyrillic from the toad, all Russian letters are replaced by '?????'.
With Cyrillic bets from the console, and output in the console, everything is fine.
When inserting Cyrillic from the console, and outputting through a toad or a php application, incomprehensible hieroglyphs.

SHOW GLOBAL VARIABLES LIKE 'char%'; 

He speaks:

| character_set_client     | latin1
     |
| character_set_connection | latin1
     |
| character_set_database   | latin1
     |
| character_set_filesystem | binary
     |
| character_set_results    | latin1
     |
| character_set_server     | latin1
     |
| character_set_system     | utf8

The real question is how to fix this mess?

UPD: After changing latin1 to utf8 in the server settings (my.ini), the following picture turned out:

| character_set_client     | utf8
     |
| character_set_connection | utf8
     |
| character_set_database   | utf8
     |
| character_set_filesystem | binary
     |
| character_set_results    | utf8
     |
| character_set_server     | utf8
     |
| character_set_system     | utf8

At the same time, the toad inserts the Cyrillic alphabet, receives the Cyrillic alphabet in the query results, now everything is ok in the application, but only hieroglyphs appear in the console (SET NAMES does not save). When I try to update with Cyrillic from the console, I get the following result:

mysql> update table set var = 'абв' where id=1;
ERROR 1366 (HY000): Incorrect string value: '\xA0\xA1\xA2' for column 'var'
at row 1

In general, I can do without a console, but the sports interest has not yet passed. Maybe someone knows how to make the Cyrillic alphabet work everywhere?

Answer 1

So the console font can be changed to utf

Answer 2

www.google.com/search?q=set+names&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla :en:official&client=firefox