X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0DD0E52D45 for ; Fri, 18 Mar 2005 22:54:24 +0000 (GMT) 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 71522-09 for ; Fri, 18 Mar 2005 22:54:15 +0000 (GMT) Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com [216.136.173.32]) by svr1.postgresql.org (Postfix) with SMTP id C06A452A4F for ; Fri, 18 Mar 2005 22:54:13 +0000 (GMT) Received: from unknown (HELO ?192.168.0.3?) (mont?rothstein@24.5.174.17 with plain) by smtp012.mail.yahoo.com with SMTP; 18 Mar 2005 22:54:15 -0000 Mime-Version: 1.0 (Apple Message framework v619.2) Content-Transfer-Encoding: 7bit Message-Id: <651dbef38351a356fc59cd02db5b38fd@yahoo.com> Content-Type: text/plain; charset=US-ASCII; format=flowed To: pgsql-admin@postgresql.org From: Mont Rothstein Subject: Multiple languages in one database Date: Fri, 18 Mar 2005 14:54:14 -0800 X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.374 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200503/293 X-Sequence-Number: 16791 I need to store multiple languages in one database (English, Spanish, Chinese, Korean, ???). At first I thought I would just us Unicode, but then I realized that it is only UTF-8 and it is my understanding that UTF-8 is insufficient for Chinese and Korean. I state this because I am starting to think that it is possible this assumption is incorrect. My question is this, is anyone storing multiple languages (including non-latin based languages such as Chinese and Korean) in one DB and if so how? My need is to store strings of text for each support language. Ex: for a given English string there would also be a Spanish, Chinese, and Korean string. This would then be used for language specific output in web pages, print (PDF?), and in email. I would really appreciate any help or pointers on this. Thanks, -Mont