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@exel.co.uk

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedOct 1, '01 at 1:34p
activeOct 1, '01 at 1:34p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Andy Hallam: 1 post

People

Translate

site design / logo © 2021 Grokbase