Varchar and multi-byte

From: "WIERS,FREDERIK (HP-Netherlands,ex1)" <frederik_wiers(at)hp(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Varchar and multi-byte
Date: 2001-09-24 12:29:04
Message-ID: 7602716236F9D3118AB50090278CE55B05F9A69A@escher.neth.hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I have a question regarding the varchar type and the multi-byte settings.
Varchar is defined as having a maximum and variable amount of characters.
When running a multi-byte database (for example Japanese), does this
definition also apply for Japanese characters ? In other words : do you
define half the amount of bytes used ?
If so, is there an alternative with which you can define a maximum number of
bytes to be stored as opposed to characters (like in Oracle : varchar2 and
SQL Server : nvarchar) ?

Please help if you can,
Fred

Browse pgsql-novice by date

  From Date Subject
Next Message Mark Tessier and Martine Veilleux 2001-09-24 12:34:59 installing postgres on virtual domain
Previous Message P.V. Subramanian 2001-09-23 04:46:17 Strange trigger behaviour