Re: UTF8 or Unicode

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: UTF8 or Unicode
Date: 2005-02-25 18:36:57
Message-ID: 200502251836.j1PIavZ24707@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Peter Eisentraut wrote:
> Am Freitag, 25. Februar 2005 16:26 schrieb Bruce Momjian:
> > OK, but what about latin1?
>
> The following character set names are specified in the SQL standard and
> therefore somewhat non-negotiable:
>
> SQL_CHARACTER
> GRAPHIC_IRV
> LATIN1
> ISO8BIT
> UTF16
> UTF8
> UCS2
> SQL_TEXT
> SQL_IDENTIFIER
>
> So we have to use LATIN1, even though it creates an inconsistency. We
> discussed this a while ago during the last great renaming, I think.
>

Oh, UTF8 and not UTF-8? I thought UTF-8 was the standard name, but if
ANSI uses UTF8 we will have to use that.

> Btw., I think ISO8BIT is the correct name for what we call SQL_ASCII, but I
> haven't analyzed that in detail, yet.

OK, please let us know.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message John Hansen 2005-02-25 18:38:29 Re: [pgsql-hackers-win32] UNICODE/UTF-8 on win32
Previous Message Marc G. Fournier 2005-02-25 18:33:28 Re: Development schedule

Browse pgsql-patches by date

  From Date Subject
Next Message Ron Mayer 2005-02-26 00:48:02 Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.
Previous Message Peter Eisentraut 2005-02-25 16:32:21 Re: UTF8 or Unicode