By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,692 Members | 1,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,692 IT Pros & Developers. It's quick & easy.

MultiByte Columns?

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Steve - DND writes:
I currently have a DB setup with ENCODING = UNICODE. Are all char, and
varchars stored as UNICODE?
Yes.
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?


One particular problem is that there is poor (i.e., no) support for
localized collation orders in Unicode databases.

--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #2

P: n/a
> > 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?


One particular problem is that there is poor (i.e., no) support for
localized collation orders in Unicode databases.


Do you know if there is there planning to make PG more Unicode friendly in
the future? If so, any idea around what version they're expecting it to be?

Thanks,
Steve


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.