Re: Best practice for: ERROR: invalid byte sequence for encoding "UTF8"

From: Ben <bench(at)silentmedia(dot)com>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Best practice for: ERROR: invalid byte sequence for encoding "UTF8"
Date: 2007-08-15 18:04:58
Message-ID: Pine.LNX.4.64.0708151059130.18380@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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. :)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-15 18:08:41 Re: pg_dump on local Windows, pg_restore on Linux?
Previous Message Decibel! 2007-08-15 18:04:29 Re: Copy command and duplicate items (Support Replace?)