Re: UTF8 or Unicode

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, Oliver Jowett <oliver(at)opencloud(dot)com>, Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, List pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: UTF8 or Unicode
Date: 2005-02-19 03:58:34
Message-ID: 6530.1108785514@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> I think we just need to _favor_ UTF8.

I agree.

> The question is where are we
> favoring Unicode rather than UTF8?

It's the canonical name of the encoding, both in the code and the docs.

regression=# create database e encoding 'utf-8';
CREATE DATABASE
regression=# \l
List of databases
Name | Owner | Encoding
------------+----------+-----------
e | postgres | UNICODE
regression | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(5 rows)

As soon as we decide whether the canonical name is "UTF8" or "UTF-8"
;-) we can fix it.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-02-19 04:15:37 Re: 8.0.X and the ARC patent
Previous Message Tom Lane 2005-02-19 03:47:21 Re: SPI_finish and RegisterExprContextCallback

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-02-20 00:56:20 WIP: write flat files at startup, enforce XID wrap limit
Previous Message Bruce Momjian 2005-02-19 03:35:07 Re: UTF8 or Unicode