Thread: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
From
venkat
Date:
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
Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
From
Thom Brown
Date:
On 22 June 2010 11:48, venkat <ven.tammineni@gmail.com> wrote: > 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 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
Re: [SQL] How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
From
Pavel Stehule
Date:
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 <ven.tammineni@gmail.com>: > 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
Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
From
Stephane Bortzmeyer
Date:
On Tue, Jun 22, 2010 at 04:18:48PM +0530, venkat <ven.tammineni@gmail.com> 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. <http://www.afnic.fr/actu/nouvelles/251/the-tunisian-internet-agency-selects-solutions-from-afnic-to-operate-its-x062a-x0648-x0646-x0633-idn-cctld>] 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