| From: | Devrim GUNDUZ <devrim(at)commandprompt(dot)com> |
|---|---|
| To: | James Dey <james(at)mygus(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Migration |
| Date: | 2006-02-10 08:58:53 |
| Message-ID: | 1139561933.16736.23.camel@evim.gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
On Fri, 2006-02-10 at 10:50 +0200, James Dey wrote:
> Am I correct in saying then that UTF-8 and UNICODE are the same thing as far
> as PostgreSQL is concerned?
Yes:
template1=# CREATE DATABASE test1 ENCODING 'UNICODE';
CREATE DATABASE
template1=# CREATE DATABASE test2 ENCODING 'UTF-8';
CREATE DATABASE
template1=# \l
List of databases
Name | Owner | Encoding
-----------+----------+----------
...
test1 | postgres | UTF8
test2 | postgres | UTF8
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bradley Kieser | 2006-02-10 10:16:08 | Re: Postgresql 8.0 or 8.1 vs. latest Red Hat RPM |
| Previous Message | James Dey | 2006-02-10 08:50:52 | Re: Migration |