Re: Search content within a bytea field

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?

Thomas