Re: [Squirrel-sql-users] viewing Postgres bytea/Oracle raw]

[Gerd W. <bir...@t-...>]

I forgot to send my reply to John to the list. Here it is now:

Hi John,

the JDBC driver has a property called "compatible" that influences how
binary data is diplayed. See

http://jdbc.postgresql.org/documentation/80/connect.html
and
http://jdbc.postgresql.org/documentation/80/binary-data.html

You can change the property in SQuirreL's alias dialog. (When you
changed the property value make sure to leave the table cell before
clicking OK, sorry for this little bug.)

If you still can't get it to work you may send me a script that creates
a table and inserts some data in a binary field. I'll check if I can
reproduce the problem.

Gerd



Joh...@we... wrote:
> Hi all,
>  
> I have some bytea binary datatypes in Postgres that I use for guids.  An 
> earlier version of Squirrel (1.2.x) allowed me to see the content of 
> those columns as ascii and not as hex, as the current version does.  
> I've played with the datatype controls to no avail.  Though I don't have 
> Oracle installed anymore, I remember having the same experience with 
> Oracle raw datatypes.  Is there an option I can change or a 
> feature/option that can be restored from a previous version to enable this?
>  
> thanks
>  
>  
> John Gregg
> Application Systems Engineer
> Wells Fargo Private Client Services Technology
>