From owner-freebsd-ports@FreeBSD.ORG Fri Aug 8 12:11:18 2003 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5F06A37B401 for ; Fri, 8 Aug 2003 12:11:18 -0700 (PDT) Received: from perrin.int.nxad.com (internal.ext.nxad.com [69.1.70.251]) by mx1.FreeBSD.org (Postfix) with ESMTP id E5DDE43FBD for ; Fri, 8 Aug 2003 12:11:17 -0700 (PDT) (envelope-from sean@nxad.com) Received: by perrin.int.nxad.com (Postfix, from userid 1001) id 4D8D320F00; Fri, 8 Aug 2003 12:11:17 -0700 (PDT) Date: Fri, 8 Aug 2003 12:11:17 -0700 From: Sean Chittenden To: Gerard Samuel Message-ID: <20030808191117.GP94710@perrin.int.nxad.com> References: <3F20163B.2000403@trini0.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3F20163B.2000403@trini0.org> X-PGP-Key: finger seanc@FreeBSD.org X-PGP-Fingerprint: 3849 3760 1AFE 7B17 11A0 83A6 DD99 E31F BC84 B341 X-Web-Homepage: http://sean.chittenden.org/ User-Agent: Mutt/1.5.4i cc: ports@FreeBSD.org cc: girgen@pingpong.net Subject: Re: FreeBSD Port: postgresql7-7.3.3 X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 08 Aug 2003 19:11:18 -0000 > Im looking for some clarification. > I just upgraded from postgresql 7.2.3, and I previously had it installed > with Multibyte support. > That option isn't available in the Postgresql 7.3.3 port. > According to the Postgresql docs, Multibyte is set enabled by default. > Cool. > Im trying to have all my databases set to "UNICODE" encoding (like how > it was when I had 7.2.3 running) > So I ran initdb with the -E switch to UNICODE. > su -l pgsql -c initdb -E UNICODE > > But the databases still have the SQL_ASCII encoding on them. > $ psql -l > List of databases > Name | Owner | Encoding > -----------+-------+----------- > template0 | pgsql | SQL_ASCII > template1 | pgsql | SQL_ASCII > (2 rows) > > But according to the docs, there may be some auto conversions from > SQL_ASCII to UNICODE > What I would like to know, is if this is true with the current > Postgresql 7.3.3 port? > So I don't have to worry about trying to get them to UNICODE, as it > seems like it cannot do so.... http://developer.postgresql.org/docs/postgres/charset.html http://developer.postgresql.org/docs/postgres/multibyte.html pgsql-general@postgresql.org list is probably more appropriate, or pgsql-novice@postgresql.org. -sc -- Sean Chittenden