From: | "Andy Hallam" <ahm(at)exel(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | UNICODE question |
Date: | 2001-09-27 10:21:53 |
Message-ID: | 9ouum4$2vm7$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all.
I have installed postgresql - version 7.1.3 on Linux 7.2
(I configured postgresql at install time with
'--enable-multibyte=UNICODE --enable-unicode-conversion'.)
I have just completed porting our current suite of C++ applications (that
use ODBC) from SQL SERVER to ORACLE and DB2 and am now attempting the same
with POSTGRESQL.
A major criteria for our software is the support of UNICODE.
Looking through the documentation at the datatypes available I am a little
confused.
For example, to store unicode data you can use the following database column
types:
SQL SERVER:
nchar, nvarchar and ntext.
ORACLE:
nvarchar2, nclob
DB2:
vargraphic, dbclob
Looking through the documentation at the available character data types
under POSTGRESQL I can only
see character() and character varying() ?. Are these types stored in 16 bit
format or ASCII 8 bit ?
Can I store a UNICODE string in a character() column on the database ??? -
surely not.
Thanks for any help.
Andy
ahm(at)exel(dot)co(dot)uk
From | Date | Subject | |
---|---|---|---|
Next Message | R Talbot | 2001-09-27 11:01:58 | Dir /pgsql/lib Files? |
Previous Message | Oleg Olenin | 2001-09-27 10:00:16 | How to get blob size? |