MySQL Bugs: #58156: GREEK CHARACTERS IN SQL EDITOR

Bug #58156	GREEK CHARACTERS IN SQL EDITOR
Submitted:	12 Nov 2010 9:13	Modified:	12 Nov 2010 13:07
Reporter:	Chris Karofillakis	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.29	OS:	Windows (XP, 7)
Assigned to:		CPU Architecture:	Any

Description:
WHEN FIELDS OR STRING VALUES, IN THE SQL EDITOR TEXT PANEL, CONSIST FROM GREEK CHARACTERS THEY ARE SHOWN AS BLANK SQUARES.

MY CONCERN IS MAINLY IN THE STRING VALUES BECAUSE IT IS TOO DIFFICULT TO WRITE THE WHERE CLAUSES AND SO ON. THE FIELDS IS NOT A VERY SERIOUS MATTER BECAUSE THEY CAN BE CHANGED IN ENGLISH. BUT THEIR CONTAINED DATA CANT BE MANIPULATED OTHERWISE. 

MYSQL 5.1 IS SETUPED IN WINDOWS 7 PRO 32BIT WITH UTF8 ENCODING OF DATA.
LET ME NOTE THAT THE DATA IN THE GRID RETURNING THE RESULTS ARE SHOWN CORRECTLY.

How to repeat:
JUST WRITE ANY LETTER IN GREEK KEYBOARD LAYOUT.

Suggested fix:
I BELIEVE THAT THE PROBLEM MUST BE SOMETHING IN THE FONT SYSTEM OF THE SQL EDITOR TEXT PANE ONLY. ANYWHERE ELSE THE CHARACTERS ARE SHOWN CORRECTLY.

The Problem Screen

Attachment: GreekCharsInSQLEditor.jpg (image/jpeg, text), 233.26 KiB.

IN THE OLDER QUERY EDITOR THE PROBLEM DID NOT EXIST

Hi Chris,
can you try to set the font setting for the editor (in preferences) to a font which you know supports that characters (the default one might not).
Thanks in advance

The default font does not support indeed the requested language characters.
Sorry to submit as a bug but never used the preferences!
Thank you for the advice.

Was this problem solved? I have run into the exact the some problem and preferences didn't have any effect. Greek characters still appear as squares.

I downloaded the latest release of MySQL workbench 5.2.31 CE rev. 7115 and Greek characters are now visible.

Many thanks to the developers.

Pavlos