Re: Best practice for: ERROR: invalid byte sequence for encoding "UTF8" - Mailing list pgsql-general

From Ben
Subject Re: Best practice for: ERROR: invalid byte sequence for encoding "UTF8"
Date
Msg-id Pine.LNX.4.64.0708151059130.18380@localhost.localdomain
Whole thread Raw
In response to Re: Best practice for: ERROR: invalid byte sequence for encoding "UTF8"  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
List pgsql-general
On Thu, 16 Aug 2007, Phoenix Kiula wrote:

> 1. Even if it were bytea, would it work with regular SQL operators
> such as regexp and LIKE?
>
> 2. Would tsearch2 work with bytea in the future as long as the stuff
> in it was text?

As far as I know, regexp, [i]like, tsearch2, etc. all require valid text
encodings, and so only work with text, not blobs. But I might be wrong.
I'm sure the manual would be enlightening. :)

pgsql-general by date:

Previous
From: Decibel!
Date:
Subject: Re: Copy command and duplicate items (Support Replace?)
Next
From: Tom Lane
Date:
Subject: Re: pg_dump on local Windows, pg_restore on Linux?