Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 28EA0687EFE; Tue, 22 Jun 2010 11:50:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 54216-01; Tue, 22 Jun 2010 14:49:56 +0000 (UTC) X-Greylist: delayed 00:06:40.070331 by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.bortzmeyer.org (aetius.bortzmeyer.org [217.70.190.232]) by mail.postgresql.org (Postfix) with ESMTP id 6CAA0687EF6; Tue, 22 Jun 2010 11:49:56 -0300 (ADT) Received: by mail.bortzmeyer.org (Postfix, from userid 10) id 65D6C94FB5; Tue, 22 Jun 2010 16:43:12 +0200 (CEST) Received: by mail.sources.org (Postfix, from userid 1000) id 4E610190670; Tue, 22 Jun 2010 16:40:17 +0200 (CEST) Date: Tue, 22 Jun 2010 16:40:17 +0200 From: Stephane Bortzmeyer To: venkat Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Subject: Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL Message-ID: <20100622144017.GA21280@sources.org> References: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: X-Transport: UUCP rules X-Operating-System: Debian GNU/Linux 5.0.4 User-Agent: Mutt/1.5.18 (2008-05-17) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201006/939 X-Sequence-Number: 164476 On Tue, Jun 22, 2010 at 04:18:48PM +0530, venkat wrote a message of 39 lines which said: > I want to insert and retrieve multilingual (Hindi) into database.is > PostgreSQL supports that ? [Currently, I'm storing arabic texts in a PostgreSQL database. ] Actually, PostgreSQL does not know about languages (except for services like full-text search): it stores text, period. For a long time, PostgreSQL was able to store texts in various encodings. The recommended one is UTF-8, which allows you to store the whole Unicode character set. % createdb --encoding=UTF-8 venkat % psql venkat venkat=> CREATE TABLE Misc (id SERIAL, content TEXT); NOTICE: CREATE TABLE will create implicit sequence "misc_id_seq" for serial column "misc.id" CREATE TABLE venkat=> INSERT INTO Misc (content) VALUES ('Texte en français'); INSERT 0 1