Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group