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