Choosing character set for database

From: Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Choosing character set for database
Date: 2011-04-20 20:29:58
Message-ID: BANLkTinZ=n9OjTnNM9YX+ciZ0+zxWyxTVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sandy Keathley 2011-04-20 23:04:00 Connecting and creating db
Previous Message Deka, Rajib IN MAA SL 2011-04-20 13:12:48 Database system identifier mismatch