Re: 8.3.0, locales, and encodings

On 2008-02-07 01:17, Tino Schwarze wrote:
> Hi Dean,
>
> On Wed, Feb 06, 2008 at 06:29:02PM -0800, Dean Gibson (DB Administrator) wrote:
>
>> 2. ... Should I be running INITDB w/ "-locale POSIX  -E UTF8", or just "-locale POSIX" (implying "-E SQL_ASCII")?
Ordoes it make a difference, since I always specify the desired database encoding when I "CREATE DATABASE... ENCODING
'...';"?
>>
>
> AFAIK, it shouldn't make a difference. -E is just the default encoding for new databases.
>
>
Actually, "-E" also affects the encoding of the base PostgreSQL
databases.  W/o "-E":

=> \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+-----------
 postgres  | postgres | SQL_ASCII
 template0 | postgres | SQL_ASCII
 template1 | postgres | SQL_ASCII

If I INITDB /w "-E UTF8":

=> \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+----------
 postgres  | postgres | UTF8
 template0 | postgres | UTF8
 template1 | postgres | UTF8


So, the interesting question is, does the difference in the encoding of
the base databases affect performance or capability in any way?

-- Dean