Re: Multiple character encodings within a single database/table?

Steve Atkins wrote:
>
> On Mar 23, 2009, at 3:50 PM, Dann Corbit wrote:
>
> > If I have the C locale, can I have multiple character encodings
> > within:
> > 1. A single database?
> > 2. A single table?
>
> No.
>
> >
> > 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?
>
> Any valid ascii string is also a valid utf8 string. You can probably
> just use utf8 for everything.

More specifically, ASCII bytes are valid UTF8 values.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +