Multiple character encodings within a single database/table? - Mailing list pgsql-general

From Dann Corbit
Subject Multiple character encodings within a single database/table?
Date
Msg-id D425483C2C5C9F49B5B7A41F89441547029620CF@postal.corporate.connx.com
Whole thread Raw
Responses Re: Multiple character encodings within a single database/table?
Re: Multiple character encodings within a single database/table?
List pgsql-general
If I have the C locale, can I have multiple character encodings within:
1.  A single database?
2.  A single table?

More specifically, I would like to be able to have Unicode columns and
ASCII text columns within the same table.  Is this possible?  If so, how
do I achieve it?

It was not clear to me from:
http://www.postgresql.org/docs/current/static/multibyte.html

It seems to me from this statement:
"It can be overridden when you create a database, so you can have
multiple databases each with a different character set."
That it may be database wide, but I am not sure that it is not possible
to have both ordinary char and Unicode in the same table.

Possible or not?


pgsql-general by date:

Previous
From: Justin Funk
Date:
Subject: Querying a Large Partitioned DB
Next
From: "Dann Corbit"
Date:
Subject: Re: INSERT or UPDATE