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: (view raw or whole thread)
Lists: pgsql-novice

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,

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-2015 The PostgreSQL Global Development Group