From: Stephane Bortzmeyer <bortzmeyer@nic.fr>
To: venkat <ven.tammineni@gmail.com>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
Date: Tue, 22 Jun 2010 16:40:17 +0200
Message-ID: <20100622144017.GA21280@sources.org> (raw)
In-Reply-To: <AANLkTinqMXze79Q3qdzegib0hH_9KXvi5hWwqos3PTv6@mail.gmail.com>
References: <AANLkTinqMXze79Q3qdzegib0hH_9KXvi5hWwqos3PTv6@mail.gmail.com>
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-...;]
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bortzmeyer@nic.fr, ven.tammineni@gmail.com, pgsql-general@postgresql.org
Subject: Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
In-Reply-To: <20100622144017.GA21280@sources.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox