Postgres Pro
Downloads
Home   >   mailing lists

Re: Search content within a bytea field - Mailing list pgsql-jdbc

From Damiano Bolzoni
Subject Re: Search content within a bytea field
Date
Msg-id 6fb522db0908302308k2775370ct55547ecdf5a732a9@mail.gmail.com
Whole thread Raw
In response to Re: Search content within a bytea field  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Tree view 
> But this does point out the problem: LIKE (a/k/a ~~) on a bytea wants
> a bytea on the righthand side, not text or varchar.  So setString is
> the wrong thing to use.

Perhaps something like:

setBytes(myString.getBytes())

?

pgsql-jdbc by date:

Previous
From: Sylvain Leroux
Date:
Subject: Re: Search content within a bytea field
Next
From: Damiano Bolzoni
Date:
Subject: Re: Search content within a bytea field