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