Re: Choosing character set for database

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