Re: values showing up as hex.

Dana,
   I have used Squirrel with the iseries/as400 and it usually works well.

Recently I have found a similar effect when using mysql:

If my column is defined as varchar the display works perfect in Squirrel.
If my column is defined as text the display will show up as Hex in Squirrel.

( You can double click on the HEX output, then you can  check the box
to display ASCII. Is your hex in ebcdic ? )

-Steve More


On 10/29/07, Dana Zimmerman  wrote:
> I have just started using Squirrel.  I am attaching to an iseries/as400
> database.  When I run a simple SQl query, my data shows up as Hex.  Does
> anyone have any ideas as to what I am doing wrong?
>
>
>
> Thanks.
>
>
>
> Dana Zimmerman
>
> dzimmerman@xxxxxxxxxx
>
> Hurd Windows and Doors, Inc.
>
> Phone: 715-748-2011 ext: 2266
>
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>
>

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/