pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
5+ messages / 5 participants
[nested] [flat]
* How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
@ 2010-06-22 10:48 venkat <ven.tammineni@gmail.com>
0 siblings, 4 replies; 5+ messages in thread
From: venkat @ 2010-06-22 10:48 UTC (permalink / raw)
To: pgsql-sql; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
@ 2010-06-22 14:38 Thom Brown <thombrown@gmail.com>
parent: venkat <ven.tammineni@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Thom Brown @ 2010-06-22 14:38 UTC (permalink / raw)
To: venkat <ven.tammineni@gmail.com>; +Cc: pgsql-sql; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
@ 2010-06-22 14:40 Stephane Bortzmeyer <bortzmeyer@nic.fr>
parent: venkat <ven.tammineni@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Stephane Bortzmeyer @ 2010-06-22 14:40 UTC (permalink / raw)
To: venkat <ven.tammineni@gmail.com>; +Cc: pgsql-sql; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [SQL] How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
@ 2010-06-22 14:40 Pavel Stehule <pavel.stehule@gmail.com>
parent: venkat <ven.tammineni@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: Pavel Stehule @ 2010-06-22 14:40 UTC (permalink / raw)
To: venkat <ven.tammineni@gmail.com>; +Cc: pgsql-sql; pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL
@ 2010-06-23 06:11 silly sad <sad@bankir.ru>
parent: venkat <ven.tammineni@gmail.com>
3 siblings, 0 replies; 5+ messages in thread
From: silly sad @ 2010-06-23 06:11 UTC (permalink / raw)
To: pgsql-sql
On 06/22/10 14:48, venkat wrote:
> I want to insert and retrieve multilingual (Hindi) into database.is
> <http://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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-06-23 06:11 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-06-22 10:48 How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL venkat <ven.tammineni@gmail.com>
2010-06-22 14:38 ` Thom Brown <thombrown@gmail.com>
2010-06-22 14:40 ` Stephane Bortzmeyer <bortzmeyer@nic.fr>
2010-06-22 14:40 ` Pavel Stehule <pavel.stehule@gmail.com>
2010-06-23 06:11 ` silly sad <sad@bankir.ru>
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