X-Original-To: pgsql-general-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 847459FA68D for ; Fri, 30 Jun 2006 11:40:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 16348-06 for ; Fri, 30 Jun 2006 11:39:58 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id 7ABA99FA163 for ; Fri, 30 Jun 2006 11:39:58 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id m18so150789nfc for ; Fri, 30 Jun 2006 07:39:56 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jO6XvLxuRHJ5Cpy11ERmZSp/ybB1sgiJ7uEvuMYqiUREoh+qKUkpUiTHCNi1KSiL/2KeA9vxamJLov3F5GEcAM3N+JEEIjxRUP6q2EYpEX3G3QvzTxZCrY2Ms3Pb+zHuYWHhFOiOU0hBfQL6kGG4s8aHLps2B2H0DXegGNlaSD4= Received: by 10.48.218.19 with SMTP id q19mr370107nfg; Fri, 30 Jun 2006 07:39:56 -0700 (PDT) Received: by 10.48.239.3 with HTTP; Fri, 30 Jun 2006 07:39:56 -0700 (PDT) Message-ID: Date: Fri, 30 Jun 2006 23:39:56 +0900 From: "Jason McManus" To: "Tom Lane" Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4 Cc: pgsql-general@postgresql.org In-Reply-To: <23557.1151677030@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <23557.1151677030@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/1211 X-Sequence-Number: 97583 > I don't believe there is any fixed "default character set". Each > installation will have a default locale and encoding, but these depend > on the locale under which initdb was run. From the above comment I > surmise that you initdb'd under some UTF8-using locale ... Ah, great. Thank you for the clarification. I did indeed run initdb on different systems, but they were all under UTF-8, so I guess I had drawn the wrong conclusion. > Perhaps they should go on the project website somewhere? I was thinking so as well, but I'm not sure where, or who to submit to if there is no wiki or other external editing method. Any pointers for who to contact/where to submit? Thanks, Jason