Skip site navigation (1) Skip section navigation (2)

Re: Search content within a bytea field

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Search content within a bytea field
Date: 2009-08-31 14:21:16
Message-ID: h7gm8l$u2k$1@ger.gmane.org (view raw or flat)
Thread:
Lists: pgsql-jdbc
Damiano Bolzoni, 31.08.2009 08:06:
> Right, I suspected that too, as I've been reading a little bit around.
> But...why if I manually query with a SQL client (AquaStudio) as
> follows:
> 
> SELECT myfield FROM mytable WHERE myfield LIKE '%hello%'
> 
> and 'myfield' is a bytea field I get the result I expected? What's the
> "trick" the client uses behind the curtains?

This looks _very_ strange (if not even wrong) to me. 

If you are storing character data, why don't you use the text datatype?

Thomas

 


In response to

pgsql-jdbc by date

Next:From: Ľubomír VargaDate: 2009-08-31 19:34:12
Subject: Possible bug in PGInterval class
Previous:From: Tom LaneDate: 2009-08-31 14:11:11
Subject: Re: Search content within a bytea field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group