From ven.tammineni@gmail.com Tue Jun 22 14:26:13 2010 Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id E43DF687D51; Tue, 22 Jun 2010 11:26:13 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 27781-05-2; Tue, 22 Jun 2010 14:26:04 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f174.google.com (mail-gx0-f174.google.com [209.85.161.174]) by mail.postgresql.org (Postfix) with ESMTP id EFCF5683CBB; Tue, 22 Jun 2010 07:48:49 -0300 (ADT) Received: by gxk26 with SMTP id 26so1324609gxk.19 for ; Tue, 22 Jun 2010 03:48:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:date:message-id :subject:from:to:content-type; bh=Bvz+m9tL4McUIQsjkAD0XaMJccW4TCMJYDA5WmNLJx0=; b=CCm5b1wMoCeKYnFoMgH/kwZ9bcksGwjt8HyRnJn6JyP24UCuNunSDC7Ppar7XHMIH3 QJdPvSt0YjrMk4QPhtVAru/+2Pz/xW7dqIM4E4DQ7c4a+C0pvySnyiIckdOvNhNAIwoQ wX0Aks0QK7Hx5/5GWnWriYWE17edSZvSFi5xk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=qm+Ra8KHaLmuCEdNoE3EBJeUxwUFleUSwD5ssPkykOnzAi/jsVuAaWNP8VvUlxnaZ0 rWTSkWTLTP6923wF52+jhLlj/UGo2BSehZHUFSfxW1UVXVSj4tN8JQDUnVic/T3ekeCc bXU0Vfjym6w2webhKbtdrFxkxGx9ELi1rVttM= MIME-Version: 1.0 Received: by 10.229.242.78 with SMTP id lh14mr3196682qcb.208.1277203728364; Tue, 22 Jun 2010 03:48:48 -0700 (PDT) Received: by 10.229.224.145 with HTTP; Tue, 22 Jun 2010 03:48:48 -0700 (PDT) Date: Tue, 22 Jun 2010 16:18:48 +0530 Message-ID: Subject: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL From: venkat To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Content-Type: multipart/alternative; boundary=00163630fe7f88f56c04899c2af2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-5 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201006/935 X-Sequence-Number: 164472 --00163630fe7f88f56c04899c2af2 Content-Type: text/plain; charset=ISO-8859-1 Dear All, I want to insert and retrieve multilingual (Hindi) into database.is PostgreSQL supports that ?if it is ... please guide me how to enable multilingual in the table. I am waiting for your great response. Thanks and Regards, Venkat --00163630fe7f88f56c04899c2af2 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Dear All,


=A0=A0I want to insert and=A0retrieve=A0multilingual (Hind= i) into database.is=A0PostgreSQL=A0suppo= rts that ?if it is ... please guide me how to enable=A0multilingual in the = table.


=A0=A0 =A0I am waiting = for your great response.

Thanks and Regards,

Venkat
--00163630fe7f88f56c04899c2af2-- From thombrown@gmail.com Tue Jun 22 14:38:58 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 46395687781 for ; Tue, 22 Jun 2010 11:38:58 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 37742-03 for ; Tue, 22 Jun 2010 14:38:49 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-ww0-f47.google.com (mail-ww0-f47.google.com [74.125.82.47]) by mail.postgresql.org (Postfix) with ESMTP id 97CAA687763 for ; Tue, 22 Jun 2010 11:38:50 -0300 (ADT) Received: by wwb22 with SMTP id 22so443121wwb.34 for ; Tue, 22 Jun 2010 07:38:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:in-reply-to :references:from:date:message-id:subject:to:cc:content-type :content-transfer-encoding; bh=FVk1knE9Rrzpjjc5oBKSCyMWFBNeCVA3sD4fuinMgQ8=; b=FbWHgVbk7CWugE5CFAxB9Bl+Forqd41HkmKTBaBokGZAuCu7gtfvqgAHtGd2q1SAwT HFawaQKiHRe+AjMxGp7rNl05VsBGM99EgfMI1DTJ371bt//2aSzd8SJF5npfc/wCz+kW EeWOqBukrteBS87+LHLeqENMPwTiTIpvfbTTA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type:content-transfer-encoding; b=NmHB/4lKJjhCdw8gY+vwsXxbuCD4e0wYr0xlCYnRuR6UL/lBu0GATuO+2xSStngpzC qo+a0+TgPv/65c1GuFrqH/5Xv9APg5uNPTLXc2x/XDh4wFe7cDnEq7LPkJKtUy9cHSRi qUpdsJf+Lv+w8wNx2Jo0VHhg9pvEBtQ1iJiG0= Received: by 10.216.89.140 with SMTP id c12mr1377227wef.78.1277217527269; Tue, 22 Jun 2010 07:38:47 -0700 (PDT) MIME-Version: 1.0 Received: by 10.216.231.221 with HTTP; Tue, 22 Jun 2010 07:38:27 -0700 (PDT) In-Reply-To: References: From: Thom Brown Date: Tue, 22 Jun 2010 15:38:27 +0100 Message-ID: Subject: Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL To: venkat Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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/937 X-Sequence-Number: 164474 On 22 June 2010 11:48, venkat wrote: > Dear All, > > =A0=A0I want to insert and=A0retrieve=A0multilingual (Hindi) into > database.is=A0PostgreSQL=A0supports that ?if it is ... please guide me ho= w to > enable=A0multilingual in the table. > > =A0=A0 =A0I am waiting for your great response. > Thanks and Regards, > Venkat Do you just mean storing Devanagari text or storing multiple languages alongside one another? If the former, I think you'll just need to set the database encoding to UTF8. If it's the latter, this may be useful to you: http://rwec.co.uk/blog/2009/11/atomic-translations-part-1/ http://rwec.co.uk/blog/2009/12/atomic-translations-part-2/ Regards Thom From bortzmeyer@nic.fr Tue Jun 22 14:50:04 2010 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 From pavel.stehule@gmail.com Tue Jun 22 14:40:54 2010 Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 124AE6877AF; Tue, 22 Jun 2010 11:40:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 86152-01; Tue, 22 Jun 2010 14:40:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yw0-f190.google.com (mail-yw0-f190.google.com [209.85.211.190]) by mail.postgresql.org (Postfix) with ESMTP id B87A06877B6; Tue, 22 Jun 2010 11:40:46 -0300 (ADT) Received: by ywh28 with SMTP id 28so3902993ywh.28 for ; Tue, 22 Jun 2010 07:40:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:mime-version:received:in-reply-to :references:from:date:message-id:subject:to:cc:content-type :content-transfer-encoding; bh=daTMklvCC+yPwmdJhoGhnrwXd3fQAc4ZSi5LT6/4EUU=; b=o4+A4cf+vhZbpj1wPaRGQCayJh/1XiTehuOOEpXDyVE/pDEJZS0D1pxk8RVGL3OPrW VnOZrHcjuWCH86KhYr9Ba5fdda6YYfU4cbsIp3JPkx03FgJ+iAUs1g7utqEtAyKAEpo9 UgUM0suwOVDy06AtYi3G2G2OA1IjcKqPQxJ4w= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc:content-type:content-transfer-encoding; b=gchQSCSpm7nHAKU1ka/mOxZJJIl3iCuqkJxJotxCBJFwZTMBgk0Fcu7SQZQa4ORZKe 32FkbgriU5n8ufNSGi4wOZ82gtkMLuT7uReSgoNsWLDv5OaGlP/HTpHc/dc+sGSv18yO Zfpne1b7Iz45Gxn5mNPFe8NTKEWUdwH0w1Ems= Received: by 10.150.56.32 with SMTP id e32mr6095962yba.127.1277217643311; Tue, 22 Jun 2010 07:40:43 -0700 (PDT) MIME-Version: 1.0 Received: by 10.151.113.8 with HTTP; Tue, 22 Jun 2010 07:40:23 -0700 (PDT) In-Reply-To: References: From: Pavel Stehule Date: Tue, 22 Jun 2010 16:40:23 +0200 Message-ID: Subject: Re: [SQL] How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL To: venkat Cc: pgsql-sql@postgresql.org, pgsql-general@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-5 required=5 tests=BAYES_40=-0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/938 X-Sequence-Number: 164475 Hello PostgreSQL doesn't support multilangual tables now - etc it isn't more than one collation per database. But you can store any langual text when this language is supported by UTF8. Just use UTF8 encoding for your database. Regards Pavel Stehule see help for initdb and createdb commands 2010/6/22 venkat : > Dear All, > > =C2=A0=C2=A0I want to insert and=C2=A0retrieve=C2=A0multilingual (Hindi) = into > database.is=C2=A0PostgreSQL=C2=A0supports that ?if it is ... please guide= me how to > enable=C2=A0multilingual in the table. > > =C2=A0=C2=A0 =C2=A0I am waiting for your great response. > Thanks and Regards, > Venkat From sad@bankir.ru Wed Jun 23 06:11:17 2010 Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 116CC6367F9 for ; Wed, 23 Jun 2010 03:11:17 -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 17257-04 for ; Wed, 23 Jun 2010 06:11:10 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moon.antora.ru (moon.antora.ru [89.111.189.180]) by mail.postgresql.org (Postfix) with ESMTP id D1C75636340 for ; Wed, 23 Jun 2010 03:11:09 -0300 (ADT) Envelope-to: pgsql-sql@postgresql.org Received: from moon.inner.space ([10.1.1.5] helo=moon.antora.ru) by moon.antora.ru with esmtp (Exim 4.67) (envelope-from ) id 1ORJAw-0003rI-0e for pgsql-sql@postgresql.org; Wed, 23 Jun 2010 10:11:06 +0400 Received: from [192.168.1.6] [178.34.6.174] by moon.antora.ru (Axigen) with (DHE-RSA-AES256-SHA encrypted) ESMTPSA id 162B9C; Wed, 23 Jun 2010 10:11:05 +0400 Message-ID: <4C21A578.8030600@bankir.ru> Date: Wed, 23 Jun 2010 10:11:04 +0400 From: silly sad User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.9.1.5) Gecko/20100111 Thunderbird/3.0 MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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/73 X-Sequence-Number: 34264 On 06/22/10 14:48, venkat wrote: > I want to insert and retrieve multilingual (Hindi) into database.is > PostgreSQL supports that ?if it is ... please guide > me how to enable multilingual in the table. in addition to the previous advice ("just use UTF-8 for entire database cluster") i notice "multilingual" is not a data layer property at all -- it's application.