X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 95A65D1B967 for ; Thu, 26 Feb 2004 05:52:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 94055-01 for ; Thu, 26 Feb 2004 01:52:01 -0400 (AST) Received: from ind-iport-1.cisco.com (ind-iport-1-sec.cisco.com [64.104.129.9]) by svr1.postgresql.org (Postfix) with ESMTP id 9CA28D1B4AA for ; Thu, 26 Feb 2004 01:51:59 -0400 (AST) Received: from india-core-1.cisco.com (64.104.129.221) by ind-iport-1.cisco.com with ESMTP; 26 Feb 2004 16:57:18 +0530 Received: from cisco.com (charminar.cisco.com [192.135.240.11]) by india-core-1.cisco.com (8.12.10/8.12.6) with ESMTP id i1Q5p6WT022191; Wed, 25 Feb 2004 21:51:07 -0800 (PST) Received: from sbiswasw2k01 (dhcp-10-77-21-42.cisco.com [10.77.21.42]) by cisco.com (8.8.8-Cisco List Logging/8.8.8) with ESMTP id LAA28408; Thu, 26 Feb 2004 11:19:14 +0530 (IST) Reply-To: From: "Sumita Biswas (sbiswas)" To: "'Tom Lane'" Cc: Subject: Unicode Support Date: Thu, 26 Feb 2004 11:21:12 +0530 Organization: cisco systems Message-ID: <002601c3fc2c$8aeffc90$2a154d0a@apac.cisco.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 Importance: Normal In-Reply-To: <20409.1077506948@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/397 X-Sequence-Number: 17087 Hi All, This is regarding Unicode Encoding(UTF8) in Postgres. I have the following assumptions, please correct me if I am wrong: 1. Postgres Supports unicode encoding(UTF8). 2. Any database takes the default encoding unless specified. Hence we can configure a Database to support unicode(UTF8) while creating the database. 3. The datatype which will store unicode data will be "character varying" as there are no other datatypes like NVARCHAR(in MSSQL) in Postgres. This will happen only when the Database is configured to support unicode(UTF8) encoding. Regards, Sumita