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
> 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?
In response to
pgsql-jdbc by date
|Next:||From: Ľubomír Varga||Date: 2009-08-31 19:34:12|
|Subject: Possible bug in PGInterval class|
|Previous:||From: Tom Lane||Date: 2009-08-31 14:11:11|
|Subject: Re: Search content within a bytea field |