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?