X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F06EF5E46E2 for ; Mon, 16 Aug 2004 12:29:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35755-06 for ; Mon, 16 Aug 2004 15:29:52 +0000 (GMT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id 7C3F75E46D2 for ; Mon, 16 Aug 2004 12:29:43 -0300 (ADT) Received: from matrix.gatewaynet.com (localhost.localdomain [127.0.0.1]) by matrix.gatewaynet.com (8.12.8/8.12.8) with ESMTP id i7GEg24T029146; Mon, 16 Aug 2004 17:42:02 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id i7GEg2nQ029142; Mon, 16 Aug 2004 17:42:02 +0300 Date: Mon, 16 Aug 2004 17:42:02 +0300 (EEST) From: Achilleus Mantzios To: Tom Lane Cc: pgsql-sql@postgresql.org Subject: Re: SQL_ASCII and UNICODE server_encoding In-Reply-To: <13567.1092668673@sss.pgh.pa.us> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/148 X-Sequence-Number: 18645 O kyrios Tom Lane egrapse stis Aug 16, 2004 : > Achilleus Mantzios writes: > > So if SQL_ASCII should be fine for UTF-8 storage. > > (here i must have missed something, tho..), whats > > the purpose of server_encoding=UNICODE? > > If you use SQL_ASCII, the server will *store* Unicode just fine, but > it won't *know* it is Unicode. So if you just want raw data storage > it doesn't matter. If you would like to sort the data, upper-case > or lower-case it, or have automatic conversions to different client > encodings, you had better tell the server the truth about what it > is storing. Thanx, i guess i didnt realize the value of conversion,sorting,etc... > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- -Achilleus