Re: invalid UTF-8 byte sequence detected - Mailing list pgsql-general

On Mar 16, 2006, at 14:42 , mike wrote:

> If you don't care to store those characters then maybe you should
> change
> the database character set to use SQL_ASCII instead of UTF-8.  I
> believe
> ASCII will quietly discard those characters when converting from
> UTF-8.

SQL_ASCII is *not* ASCII. See the "What's a good default encoding?"
thread on this same list from today.

http://archives.postgresql.org/pgsql-general/2006-03/msg00685.php

I don't believe it will discard anything on import if the database is
SQL_ASCII encoded.

Michael Glaesemann
grzm myrealbox com