X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 851989DC81A for ; Fri, 10 Feb 2006 04:58:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31719-10 for ; Fri, 10 Feb 2006 04:58:58 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id C8C949DC818 for ; Fri, 10 Feb 2006 04:58:55 -0400 (AST) Received: from evim.gunduz.org (dsl.static8121514250.ttnet.net.tr [81.215.14.250] (may be forged)) (authenticated bits=0) by projects.commandprompt.com (8.13.4/8.13.4) with ESMTP id k1A96PKE031107; Fri, 10 Feb 2006 01:06:27 -0800 Subject: Re: Migration From: Devrim GUNDUZ To: James Dey Cc: "pgsql-admin@postgresql.org" In-Reply-To: <20060210085056.AE4BE31DB@ctb-mesg9.saix.net> References: <20060210085056.AE4BE31DB@ctb-mesg9.saix.net> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Fri, 10 Feb 2006 10:58:53 +0200 Message-Id: <1139561933.16736.23.camel@evim.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-22) Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.87.1, clamav-milter version 0.87 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Fri, 10 Feb 2006 01:06:28 -0800 (PST) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.16 required=5 tests=[AWL=0.160, UPPERCASE_25_50=0] X-Spam-Score: 0.16 X-Spam-Level: X-Archive-Number: 200602/98 X-Sequence-Number: 20519 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/