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 96FC69DCAE2 for ; Tue, 7 Mar 2006 12:22:21 -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 59524-01 for ; Tue, 7 Mar 2006 12:22:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web53907.mail.yahoo.com (web53907.mail.yahoo.com [206.190.36.217]) by postgresql.org (Postfix) with SMTP id D4B5F9DC840 for ; Tue, 7 Mar 2006 12:22:17 -0400 (AST) Received: (qmail 57965 invoked by uid 60001); 7 Mar 2006 16:22:16 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=aejraL3/nymf6cWDjr1GHvUsTtq218D6VGcVKbyQCA+PPkNLeURzTDBTzPQgr8RwrFGowHd0WYUr8YQ0tBfGM1TMlWLvUQkAb8LftZacacKkM5ahlAkuo02sAP7HpxOBUq12/wbPiq5gixrlm2jliUzxh2jB4uC11/UZMx/tE/Y= ; Message-ID: <20060307162216.57963.qmail@web53907.mail.yahoo.com> Received: from [24.188.184.164] by web53907.mail.yahoo.com via HTTP; Tue, 07 Mar 2006 08:22:16 PST Date: Tue, 7 Mar 2006 08:22:16 -0800 (PST) From: ow Subject: Re: New database: SQL_ASCII vs UTF-8 trade-offs To: pgsql-admin@postgresql.org In-Reply-To: <19681.1141747646@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.138 required=5 tests=[AWL=-0.220, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, UPPERCASE_25_50=0] X-Spam-Score: 1.138 X-Spam-Level: * X-Archive-Number: 200603/72 X-Sequence-Number: 20829 --- Tom Lane wrote: > It seems risky, but you could probably get away with that as long > as the database locale (LC_COLLATE/LC_CTYPE) is "C" ... which is really > the only one that's safe with SQL_ASCII anyway ... I actually created the cluster with: test1:~# /usr/lib/postgresql/8.1/bin/initdb --pwprompt -D /var/lib/postgresql/8.1/main/ --lc-collate=POSIX test1:~# locale LANG= LC_CTYPE="POSIX" LC_NUMERIC="POSIX" LC_TIME="POSIX" LC_COLLATE="POSIX" LC_MONETARY="POSIX" LC_MESSAGES="POSIX" LC_PAPER="POSIX" LC_NAME="POSIX" LC_ADDRESS="POSIX" LC_TELEPHONE="POSIX" LC_MEASUREMENT="POSIX" LC_IDENTIFICATION="POSIX" LC_ALL= Not sure if it's going to make a difference. Thanks __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com