MySQL Workbench CONCAT showing BLOB data fix

If you find CONCAT results over a remote connection bringing a BLOB value use the following to fix this.

fix confirmed in repository.
option: “Treat BINARY/VARBINARY as nonbinary character string” has been added to app
Preferences “SQL Editor” section

4 Comments

VG March 3, 2012 at 2:19 am

Only added note is I had to restart Workbench for this to take affect.

Nice fix, thank you!

Reply ↓
Aizkor May 11, 2012 at 11:29 am

Thanks a lot. Nice fix.

Reply ↓
TL April 10, 2013 at 1:03 am

This isn’t working for me…. I’m changing the setting and restarting the program and I’m still getting a “blob” value. Using Mac OS X 10.8.3 and Workbench 5.2.47. What am I missing?

Reply ↓
Den December 30, 2013 at 11:27 am

Thanks! I found this settings in Edit -> Preferences -> SQL Queries and didn’t had to restart Workbench (Version 6.0.8).

Reply ↓