Re: [HACKERS] Invalid unicode in COPY problem

Tatsuo Ishii wrote:
> Sent: Sunday, May 08, 2005 12:01 PM
> To: linux@alteeve.com
> Cc: pgsql-general@postgresql.org; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] [GENERAL] Invalid unicode in COPY problem
>
> We have developed patches which relaxes the character
> validation so that PostgreSQL accepts invalid characters. It
> works like this:

That is just plain 100% wrong!!
Under no circumstances should there be invalid data in a database.
And if you're trying to make a database of invalid data, then at
least encode it using a valid encoding.

In fact, I've proposed strengthening the validation routines for UTF-8.

... John