Lists: | pgsql-hackers |
---|
From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | FW: Multiple character encodings within a single database/table? |
Date: | 2009-03-24 19:08:21 |
Message-ID: | D425483C2C5C9F49B5B7A41F89441547029620D4@postal.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
> -----Original Message-----
> From: Dann Corbit
> Sent: Monday, March 23, 2009 3:50 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Multiple character encodings within a single database/table?
>
> 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?
I know that this message is better placed on the general group, but I
got no reply in 24 hours.
So perhaps I can get a rise in hackers...
From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Dann Corbit <DCorbit(at)connx(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: FW: Multiple character encodings within a single database/table? |
Date: | 2009-04-10 15:18:32 |
Message-ID: | 200904101518.n3AFIWH28009@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Dann Corbit wrote:
> > -----Original Message-----
> > From: Dann Corbit
> > Sent: Monday, March 23, 2009 3:50 PM
> > To: pgsql-general(at)postgresql(dot)org
> > Subject: Multiple character encodings within a single database/table?
> >
> > 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?
>
> I know that this message is better placed on the general group, but I
> got no reply in 24 hours.
> So perhaps I can get a rise in hackers...
ASCII is a non-encoding, in my mind, so it can be safely used with any
other encoding in the same database or table.
--
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. +