Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id F33FA9FA8EF for ; Tue, 28 Nov 2006 07:35:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 79910-08 for ; Tue, 28 Nov 2006 07:34:55 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web58309.mail.re3.yahoo.com (web58309.mail.re3.yahoo.com [68.142.236.162]) by postgresql.org (Postfix) with SMTP id A820C9FB1C0 for ; Tue, 28 Nov 2006 07:34:55 -0400 (AST) Received: (qmail 34443 invoked by uid 60001); 28 Nov 2006 11:34:53 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=TiVm9QzGcKhHc7pNSOOElSI0J+uPA/H1DeaUhkuT6K1bz4+p0adtORRFbK19g6GdbTCoyJIV53edzOhyNG3KtX+V8sp2RPcSGGXPLiIxD+tf6/7aZcbjAtvEeiVTElRRUhIBtnAVOzhgXO0L7iCFkZCgbqrIDdRwTfAUYPqyQoM= ; Message-ID: <20061128113453.34441.qmail@web58309.mail.re3.yahoo.com> Received: from [129.165.226.2] by web58309.mail.re3.yahoo.com via HTTP; Tue, 28 Nov 2006 03:34:53 PST Date: Tue, 28 Nov 2006 03:34:53 -0800 (PST) From: Jessica Richard Subject: how do I create a db with unicode encoding on a utf8 server To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2124143500-1164713693=:28071" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.757 tagged_above=0 required=5 tests=BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200611/224 X-Sequence-Number: 23751 --0-2124143500-1164713693=:28071 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I have a Postgre server with UTF8 as the default encoding. I am trying to create a new database on this same server with UNICODE encoding so that I can load an UNICODE database from another server. No matter how I specify unicode option on this utf8 server, it just created a utf8 db for me any way. Can different databases have different encodings on the same server? I remember they could before.... Thanks, Jessica --------------------------------- Want to start your own business? Learn how on Yahoo! Small Business. --0-2124143500-1164713693=:28071 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit I have a Postgre server with UTF8 as the default encoding. I am trying to create a new database on this same server  with UNICODE encoding so that I can load an UNICODE database from another server. No matter how I specify unicode option on this utf8 server, it just  created a utf8 db for me any way. Can different databases have different encodings on the same server? I remember they could before....

Thanks,
Jessica


Want to start your own business? Learn how on Yahoo! Small Business. --0-2124143500-1164713693=:28071--