Re: UTF8 or Unicode - Mailing list pgsql-hackers

From Tom Lane
Subject Re: UTF8 or Unicode
Date
Msg-id 6530.1108785514@sss.pgh.pa.us
Whole thread Raw
In response to Re: UTF8 or Unicode  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: UTF8 or Unicode  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.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 | UNICODEregression | postgres | SQL_ASCIItemplate0  |
postgres| SQL_ASCIItemplate1  | 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SPI_finish and RegisterExprContextCallback
Next
From: Bruce Momjian
Date:
Subject: Re: 8.0.X and the ARC patent