On Tue, Jun 22, 2010 at 04:18:48PM +0530, venkat <ven.tammineni@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
