Re: Search content within a bytea field

From: Damiano Bolzoni <damiano(dot)bolzoni(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Sylvain Leroux <sl20(at)wanadoo(dot)fr>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Search content within a bytea field
Date: 2009-08-31 06:08:43
Message-ID: 6fb522db0908302308k2775370ct55547ecdf5a732a9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

> 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())

?

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Sylvain Leroux 2009-08-31 07:38:49 Re: Search content within a bytea field
Previous Message Damiano Bolzoni 2009-08-31 06:06:36 Re: Search content within a bytea field