Re: [GENERAL] Multiple character encodings within a single database/table?
Dann Corbit dcor...@connx.com writes: If I have the C locale, can I have multiple character encodings within: 1. A single database? 2. A single table? No. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Multiple character encodings within a single database/table?
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. Cheers, Steve -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 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 br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general