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 1C2105E46E1 for ; Thu, 26 Aug 2004 17:36:33 -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 07026-08 for ; Thu, 26 Aug 2004 20:36:30 +0000 (GMT) Received: from sccrmhc12.comcast.net (sccrmhc12.comcast.net [204.127.202.56]) by svr1.postgresql.org (Postfix) with ESMTP id F1FD15E46C3 for ; Thu, 26 Aug 2004 17:36:28 -0300 (ADT) Received: from hivemind.trini0.org (trini0.org[65.34.205.195]) by comcast.net (sccrmhc12) with ESMTP id <2004082620362601200p7h95e>; Thu, 26 Aug 2004 20:36:30 +0000 Received: from [192.168.0.3] (gladiator.trini0.org [192.168.0.3]) by hivemind.trini0.org (Postfix) with ESMTP id 34306168 for ; Thu, 26 Aug 2004 16:36:26 -0400 (EDT) Message-ID: <412E49C9.8050609@trini0.org> Date: Thu, 26 Aug 2004 16:36:25 -0400 From: Gerard Samuel User-Agent: Mozilla Thunderbird 0.7.3 (X11/20040812) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Space requirements (with respect to foriegn languages) 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/42 X-Sequence-Number: 2930 My site/code/database is developed primarily for the english language. I've had people from "The Far East" add content to my site using their native language, and it is displaying properly in the site. But Im a bit concerned about the number of characters these languages use. For example, I've had someone enter -> chinese testing 中文 It is saved in the database as -> chinese testing 中文 Now, forgive my ignorance, but I have no idea what the additional chinese characters mean, but from the values in the database, Im assuming that it amounts to 3 characters. But if Im correct that those are 3 characters, it is using up 24 characters in a column. My concern is that what if I were to limit a column to say 25 "english" characters, and a chinese fellow, comes by and hypothetically says "Hello World" in chinese and goes over the limit of the column, the data will be truncated. Is there anything that can be done to overcome this shortcoming? Im currently using PostgreSQL 7.4.2, using SQL_ASCII as the database characterset, FreeBSD 4.10, php 4.3.6. Thanks for any advise you can provide...