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
Only added note is I had to restart Workbench for this to take affect.
Nice fix, thank you!
Thanks a lot. Nice fix.
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?
Thanks! I found this settings in Edit -> Preferences -> SQL Queries and didn’t had to restart Workbench (Version 6.0.8).
Leave a Reply