Bug #62345 Does not support Cyrillic comments in stored procedures

• Submitted: 4 Sep 2011 19:24
• Modified: 7 Feb 2012 13:38
• Reporter: Анатолий Кирсанов
• Status: Duplicate
• Category: MySQL Workbench: SQL Editor
• Severity: S3 (Non-critical)
• Version: 5.2.35
• OS: Windows (Vista SP2 Home Basic Russian)
• CPU Architecture: Any

[4 Sep 2011 19:24] Анатолий Кирсанов

Description:
When you enter comments in Cyrillic keyboard layout it prints boxes instead of letters.

How to repeat:
1. Start Workbench
2. Click on Open connection to start querying
3. Enter connection params (login, password, server ...)
4. Click on Actions/Add routine
5. In the opened editor windows change keyboard layout to russian.
6. Enter some comments.

[4 Sep 2011 19:25] Анатолий Кирсанов

Cyrillic comments example

Attachment: workbench-sqleditor-storedproc-russiancomments.jpg (image/jpeg, text), 80.35 KiB.

[4 Sep 2011 21:41] Анатолий Кирсанов

The same problem in Query window (just press 'Create a new Scratch Area for executing queries button' on toolbar in SQL Editor). It is impossible to enter, e.g. INSERT command containing Cyrillic strings for CHAR or VARCHAR columns.

By the way, SHOW VARIABLES LIKE 'character_set%'; yields

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
character_sets_dir, C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\

In my.ini

default-character-set=cp866 (for mysql.exe, http://forums.mysql.com/read.php?47,430452,431984#msg-431984)

character-set-server=utf8

[5 Sep 2011 10:49] Valeriy Kravchuk

Thank you for the bug report. Verified on Windows XP.

[25 Sep 2011 17:24] Valeriy Kravchuk

Bug #62509 was marked as a duplicate of this one.

[26 Sep 2011 6:16] Valeriy Kravchuk

Bug #62539 was marked as a duplicate of this one.

[6 Nov 2011 20:04] Анатолий Кирсанов

The same in 5.2.35 version.

Possible workaround:

1. Enter to preferences menu (Edit/Preferences).
2. Click on Appearance tab.
3. Change Editor font to Tahoma 11 (for my situation).
4. Reopen your script file or open new SQL tab or reopen Workbench.

[7 Feb 2012 13:38] Mike Lischke

Duplicate of Bug #62328

[6 Mar 2012 3:43] Yury Merezhuk

This not a bug, but wrong configuration of the SQL editor default font name.
All credits goese to Vacheslav Starikov and Google
( http://starikovs.com/2011/02/20/change-font-mysql-workbench-editor/ )
In C:\Users\User\AppData\Roaming\MySQL\Workbench\wb_options.xml find workbench.general.Editor:Font and change font to any with alpahbet you need.

For cyrillic auther used Vernada, 'Lucda Sans Unicode'  is fine too.
<value type="string" key="workbench.general.Editor:Font">
  Verdana
</value>

Thank you, Vacheslav!