Skip site navigation (1) Skip section navigation (2)

Re: Choosing character set for database

From: Susanne Ebrecht <susanne(at)2ndQuadrant(dot)com>
To: Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Choosing character set for database
Date: 2011-04-21 11:49:11
Message-ID: 4DB019B7.3020307@2ndQuadrant.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 20.04.2011 22:29, Grzegorz Szpetkowski wrote:
> Is there any clear performance difference of using multi-byte
> character set (such as UTF-8) and single-byte (e.g. SQL_ASCII,
> LATIN2). Why there is no UTF-32 (generally more space for chars, but
> faster to calculate than multibyte ?) ? I found only at Oracle 11g
> documentation that:

Hello Grzegorz,

PostgreSQL didn't implement own character sets.
We just use what libc provide. Means what you find on your OS.

My information is there is no operating system using UTF-32.

Did you ever feel a performance difference on your OS when you used ISO 
instead
of UTF8?

Regards,

Susanne

-- 
Susanne Ebrecht - 2ndQuadrant
PostgreSQL Development, 24x7 Support, Training and Services
www.2ndQuadrant.com


In response to

Responses

pgsql-novice by date

Next:From: Sandy KeathleyDate: 2011-04-21 15:27:04
Subject: pgAdmin vs phpPgAdmin
Previous:From: Michael WoodDate: 2011-04-21 08:30:32
Subject: Re: Connecting and creating db

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group