Choosing character set for database - Mailing list pgsql-novice

From Grzegorz Szpetkowski
Subject Choosing character set for database
Date
Msg-id BANLkTinZ=n9OjTnNM9YX+ciZ0+zxWyxTVQ@mail.gmail.com
Whole thread Raw
Responses Re: Choosing character set for database
List pgsql-novice
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:

"For best performance, choose a character set that avoids character
set conversion and uses the most efficient encoding for the languages
desired. Single-byte character sets result in better performance than
multibyte character sets, and they also are the most efficient in
terms of space requirements. However, single-byte character sets limit
how many languages you can support."

Regards,
Grzegorz Sz.

pgsql-novice by date:

Previous
From: "Deka, Rajib IN MAA SL"
Date:
Subject: Database system identifier mismatch
Next
From: "Sandy Keathley"
Date:
Subject: Connecting and creating db