BLOBs contain binary data and are always displayed in Hexadecimal. It
is a bit unusual to store DOUBLE values in a BLOB field. But If that
is what you have, you can double-click on the BLOB field that is
showing you binary data represented in hexadecimal, then you can check
the box that says "Show ASCII as chars", and you should see your
DOUBLE value.
Rob
On Wed, Nov 19, 2008 at 3:46 AM, porchrat <por...@gm...> wrote:
>
> Hi all this is my first post and I'm having a problem. I have some DOUBLE
> and BLOB values in a MySQL table that are displayed in SQuirrel as
> hexadecimal values. Does anyone have any experiences with this happening?
>
> If I can't solve this I'm going to have to move to another report writer,
> which is unfortunate as I really enjoy using SQuirrel.
> --
> View this message in context: http://www.nabble.com/Problems-with-BLOB-and-DOUBLE-values-tp20575725p20575725.html
> Sent from the squirrel-sql-users mailing list archive at Nabble.com.
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
|
