MySQL Bugs: #53605: cannot change font in SQL editor and default is ugly

Bug #53605	cannot change font in SQL editor and default is ugly
Submitted:	12 May 2010 18:11	Modified:	28 May 2010 13:46
Reporter:	Aaron Hagopian	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.21	OS:	Linux (Fedora 12)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
After installing workbench 5.2.21 on my x86_64 fedora 12 linux machine the fonts for the SQL editor do not look good.  In all the previous versions I never had this issue.  I see in the console output I see this:

The font "-*-Bitstream Vera Sans Mono-medium-r-*-*-*-100-*-*-*-*-iso10646-1,-*-*-medium-r-*-*-*-100-*-*-*-*-iso8859-*" does not support all the required character sets for the current locale "en_US.UTF-8"
  (Missing character set "ISO8859-13")
  (Missing character set "JISX0208.1983-0")
  (Missing character set "KSC5601.1987-0")
  (Missing character set "GB2312.1980-0")
  (Missing character set "JISX0201.1976-0")

I also never noticed that when you try to change the font its just a text field, so I do not know what font will be acceptible.  When I change the font I see a similar message and the font actually never changes.  The only thing that I can seem to adjust in the preferences is the font size.

How to repeat:
Install 5.2.21 and go to the sql editor

Thank you for the bug report.

While having to enter the font as text is a shortcoming the feature is working on our testsystems. You need to re-open a editor tab for the changes to take effect.

I was able to get it to change font size when opening a new editor window but the font never changes.  I never had to even mess with this before 5.2.21.  And whatever font it is actually using in the editor, its very hard on the eyes.

For instance trying to use Helvetica or Liberation Sans gives basically the same message.

(mysql-workbench-bin:7129): Gtk-CRITICAL **: gtk_box_pack: assertion `child->parent == NULL' failed

(mysql-workbench-bin:7129): Gtk-CRITICAL **: gtk_box_pack: assertion `child->parent == NULL' failed
** Message: TreeViewImpl::add_column: handle width!
** Message: TreeViewImpl::add_column: handle width!
The font "-*-Helvetica-medium-r-*-*-*-110-*-*-*-*-iso10646-1,-*-*-medium-r-*-*-*-110-*-*-*-*-iso8859-*" does not support all the required character sets for the current locale "en_US.UTF-8"
  (Missing character set "ISO8859-13")
  (Missing character set "KSC5601.1987-0")
  (Missing character set "GB2312.1980-0")
  (Missing character set "JISX0201.1976-0")

(mysql-workbench-bin:7129): Gtk-CRITICAL **: gtk_box_pack: assertion `child->parent == NULL' failed

(mysql-workbench-bin:7129): Gtk-CRITICAL **: gtk_box_pack: assertion `child->parent == NULL' failed
** Message: TreeViewImpl::add_column: handle width!
** Message: TreeViewImpl::add_column: handle width!
The font "-*-Liberation Sans-medium-r-*-*-*-110-*-*-*-*-iso10646-1,-*-*-medium-r-*-*-*-110-*-*-*-*-iso8859-*" does not support all the required character sets for the current locale "en_US.UTF-8"
  (Missing character set "ISO8859-13")
  (Missing character set "KSC5601.1987-0")
  (Missing character set "GB2312.1980-0")
  (Missing character set "JISX0201.1976-0")

Can you paste a screenshot? With the old font we were getting bug reports that it was ugly and huge

clean workbench user folder, default editor for me

Attachment: wb1.png (image/png, text), 98.21 KiB.

now up the font size to 12, also tried changing the font to Helvetica, size takes effect but font family ignored (and ugly)

Attachment: wb2.png (image/png, text), 98.01 KiB.

Apparently there is a problem with the DPI interpretation in the editor control, in my screen the default looks much bigger. The ugly font is just the fallback because Helvetica couldn't be used by the editor control. Try Bitstream Vera Sans Mono 12 or some bigger size.

Also, please provide DPI setting being used in GNOME (you can see it in System -> Preferences -> Appearance Preferences -> Fonts -> Details...) and your actual screen resolution.

downgraded back to 5.2.20 and fonts looked better

Attachment: wb3.png (image/png, text), 104.00 KiB.

I downgraded to 5.2.20 to make sure it wasn't a system update or something and the fonts looked better again so its something in the .21 that makes a difference.  I noticed running .20 that changing the font size didn't seem to do anything even after closing the editor window.

As for my DPI settings I run KDE but that shouldn't make too much of a difference  but my DPI settings under the gnome settings are 96 and smoothing is set to grayscale and hinting at medium.  Subpixel order is RGB.

I run a dual head setup so my resolution is technically 2560 x 1024 but really each monitor is running at 1280x1024.

Font handling in Linux was changed so that if Editor font in Preferences is left blank, the old default
is used.

fix confirmed in repository

An entry has been added to the 5.2.22 changelog:

Specifying a new font for the SQL Editor's SQL Query tab contents had no affect on appearance.