Datatype for large UNICODE string storage

From: "Andy Hallam" <ahm(at)exel(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Datatype for large UNICODE string storage
Date: 2001-10-01 13:07:23
Message-ID: 9p9psi$29ev$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Could someone out there tell me what datatype to use for storing large
amounts of unicode string data in PostgreSQL?

I.e :

In SQL SERVER I would use :
CREATE TABLE BigText
(
MyID NVARCHAR(10),
MyText NTEXT
)

In ORACLE I would use :
CREATE TABLE BigText
(
MyID NVARCHAR2(10),
MyText NCLOB
)

In DB2 I would use :
CREATE TABLE BigText
(
MyID VARGRAPHIC(10),
MyText DBCLOB(1M)
)

In PostgreSQL I would use :
CREATE TABLE BigText
(
MyID NCHAR VARYING(10),
MyText ??????????????
)

The maximum I would need to store is around 1M.

Thanks in advance for any help given.

Andy.
ahm(at)exel(dot)co(dot)uk

Browse pgsql-general by date

  From Date Subject
Next Message Andy Hallam 2001-10-01 13:08:53 Re: CREATION OF PRIMARY KEYS
Previous Message Tille, Andreas 2001-10-01 11:05:47 Re: Performance question (stripped down the problem)