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 891895E46C0 for ; Mon, 16 Aug 2004 11:44:18 -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 15776-04 for ; Mon, 16 Aug 2004 14:44:15 +0000 (GMT) Received: from matrix.gatewaynet.com (matrix.gatewaynet.com [217.19.69.50]) by svr1.postgresql.org (Postfix) with ESMTP id A7FBF5E46EC for ; Mon, 16 Aug 2004 11:44:11 -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 i7GDuT4T029050 for ; Mon, 16 Aug 2004 16:56:29 +0300 Received: from localhost (achill@localhost) by matrix.gatewaynet.com (8.12.8/8.12.8/Submit) with ESMTP id i7GDuTr4029046 for ; Mon, 16 Aug 2004 16:56:29 +0300 Date: Mon, 16 Aug 2004 16:56:29 +0300 (EEST) From: Achilleus Mantzios To: pgsql-sql@postgresql.org Subject: SQL_ASCII and UNICODE server_encoding In-Reply-To: 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/146 X-Sequence-Number: 18643 Hi, i'd like to ask if there is any difference in server_encoding SQL_ASCII and UNICODE (there must be one since the different terms), but AFAIU -databases which store in SQL_ASCII (i.e. server_encoding=SQL_ASCII) have no problem storing 8bit chars with the first bit set. -databases with server_encoding=UNICODE actually store in UTF-8 encoding -The purpose of UTF-8 is to make possible that multibyte chars can be stored in systems that represent chars in 8 bits -So SQL_ASCII is fine for UTF-8, hence multibyte UNICODE. 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? -- -Achilleus