I'm trying to search for some content within a bytea field. My
PreparedStatement looks like this:
SELECT id FROM mytable WHERE myfield LIKE ?
Now, when I execute a
ps.setString(1, "%" + value + "%")
where 'value' is the value I want to search for, the PS becomes
SELECT id FROM mytable WHERE myfield LIKE %VALUE%
and the query clearly fails ("operator does not exist: bytea ~~
character varying"). Now, my question is....why? What am I doing
Thanks for you help!
pgsql-jdbc by date
|Next:||From: Sylvain Leroux||Date: 2009-08-30 21:51:51|
|Subject: Re: Search content within a bytea field|
|Previous:||From: Brett Henderson||Date: 2009-08-30 06:24:43|
|Subject: Re: Prepared Statement Query Planning|