X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C33E55E46D4 for ; Sat, 28 Aug 2004 17:23:59 -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 63834-03 for ; Sat, 28 Aug 2004 20:23:58 +0000 (GMT) Received: from rwcrmhc12.comcast.net (rwcrmhc12.comcast.net [216.148.227.85]) by svr1.postgresql.org (Postfix) with ESMTP id 446D25E46F8 for ; Sat, 28 Aug 2004 17:23:56 -0300 (ADT) Received: from hivemind.trini0.org (trini0.org[65.34.205.195]) by comcast.net (rwcrmhc12) with ESMTP id <20040828202357014008l0g9e>; Sat, 28 Aug 2004 20:23:58 +0000 Received: from [192.168.0.3] (gladiator.trini0.org [192.168.0.3]) by hivemind.trini0.org (Postfix) with ESMTP id 34A971A4; Sat, 28 Aug 2004 16:23:57 -0400 (EDT) Message-ID: <4130E9DE.9020701@trini0.org> Date: Sat, 28 Aug 2004 16:23:58 -0400 From: Gerard Samuel User-Agent: Mozilla Thunderbird 0.7.3 (X11/20040812) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Markus Bertheau Cc: pgsql-php@postgresql.org Subject: Re: Space requirements (with respect to foriegn languages) References: <412E49C9.8050609@trini0.org> <1093703976.2732.5.camel@teetnang> In-Reply-To: <1093703976.2732.5.camel@teetnang> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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/45 X-Sequence-Number: 2933 Markus Bertheau wrote: > В Чтв, 26.08.2004, в 22:36, Gerard Samuel пишет: >>Im currently using PostgreSQL 7.4.2, using SQL_ASCII as the database >>characterset, FreeBSD 4.10, php 4.3.6. > > > Change your site to use a character set that includes chinese > characters, for example Unicode. The most common encoding of Unicode on > the web is UTF-8. It's also the encoding PostgreSQL uses when you use > UNICODE as the database encoding. > > If you decide to switch your site to UTF-8 and want varchar(25) to mean > 25 characters, and not 25 bytes, you have to change the database > encoding to UNICODE accordingly. > I'll try some mock scripts to see if it will pan out... Thanks