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


  1. VG

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

    Nice fix, thank you!

  2. Aizkor

    Thanks a lot. Nice fix.

  3. TL

    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?

  4. Den

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


Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>