Re: invalid UTF-8 byte sequence detected

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: mike <mike(at)thegodshalls(dot)com>
Cc: Wes <wespvp(at)syntegra(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: invalid UTF-8 byte sequence detected
Date: 2006-03-16 06:13:42
Message-ID: 269F88E2-E97F-47CE-B232-E224F1350FCC@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message karly 2006-03-16 06:30:13 Re: Indexes on array columns
Previous Message Wes 2006-03-16 06:01:53 Re: invalid UTF-8 byte sequence detected