MultiByte columns

From: "Steve - DND" <nntp(at)digitalnothing(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: MultiByte columns
Date: 2003-11-17 00:40:40
Message-ID: 0OUtb.6035$SV2.2075@okepread01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I currently have a DB setup with ENCODING = UNICODE. Are all char, and
varchars stored as UNICODE? I predominantly work in a SQL Server
environment, and there we have varchar for regular ASCII, and nvarchar for
Unicode, so the extra space is used only when necessary. I just wanted to
find out if PG takes care of this behind the scenes, or if everything for
the DB is stored as multi-byte.

Also, I get the general impression(from newsgroups, forums, etc...) that PG
is rough around the edges when dealing with Unicode, is this the case, or
just a bunch of noisy people?

Thanks,
Steve

Browse pgsql-general by date

  From Date Subject
Next Message Keith C. Perry 2003-11-17 00:56:01 Re: Retoring non-administrative user databases
Previous Message Stephan Szabo 2003-11-16 22:22:35 Re: Conservation of OIDs