Re: invalid UTF-8 byte sequence detected

From: Wes <wespvp(at)syntegra(dot)com>
To: Michael Glaesemann <grzm(at)myrealbox(dot)com>
Cc: mike <mike(at)thegodshalls(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: invalid UTF-8 byte sequence detected
Date: 2006-03-16 06:49:38
Message-ID: C03E66A2.20DC8%wespvp@syntegra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/16/06 12:41 AM, "Michael Glaesemann" <grzm(at)myrealbox(dot)com> wrote:

> I hope you didn't take my comments as a suggestion: I think you
> *should* preprocess your data and use UTF8 as the default encoding
> (or another encoding that includes all of the characters you hope to
> use) for your database.

Yeah, after thinking about it some more, it probably isn't such a good idea
- it would make the database act rather strange with non U.S. Data. I
really hate to have to burn the cycles to validate anything that looks like
extended UTF-8 characters, only to have Postgres do it again. But maybe
there's no choice.

Wes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2006-03-16 08:36:40 Re: question about postgresql time intervals
Previous Message Harald Armin Massa 2006-03-16 06:41:44 Re: PostgreSQL on Windows not starting