Hi,

In the postgres documentation we can read that space used by short
string (<126 bytes) = 1 byte + size of the string.
And longer string = 4 byte + size of the string

I understand that for character varying(n) or character varying, but for
a character(n) is it really the same things ?

Because a character(4) already used 4 bytes (it already completed with
blanck space). So why specify the space in each string if we know it

On 2010-10-01, bcar <bcar44 (AT) laposte (DOT) net> wrote:
charcter(4) is is not always 4 bytes.

eg: '𥐯𥐰𥒲𥕞' which is 4 characters takes takes 16 bytes for the
character data (and (I guess) 1 byte for the length ).

Read the page on character data types for more info.
http://www.postgresql.org/docs/9.0/i...character.html

--
¡spuɐɥ ou 'ɐꟽ ʞooꞀ