MultiByte columns - Mailing list pgsql-general

From Steve - DND
Subject MultiByte columns
Date
Msg-id 0OUtb.6035$SV2.2075@okepread01
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: uploading files
Next
From: "Yury Shvetsov"
Date:
Subject: SQL text of view