UNICODE question

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

Browse pgsql-general by date

  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?