internationalizing text

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: internationalizing text
Date: 2001-03-23 04:06:49
Message-ID: 20010322220649.B15195@mail.serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

so who's got a clever implementation of cross-linguistic texts?

create table something (
id serial,
yadayada int4,
whatever date,
mumble float8,

en varchar(50), -- english
es varchar(50), -- espanol
fr varchar(50), -- francais
de varchar(50), -- deutsch

...
);

or maybe

create table something (
id serial,
yadayada int4,
whatever date,
mumble float8,
...
);
create table something_text (
id int4 references something(id),
lang varchar(5), -- language code 'en-us','it','jp'...
descr varchar(50)
);

anybody done something like this? is there another concept or are
these two the whole ball-o-wax? pro's and con's?

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will(at)serensoft(dot)com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-23 04:23:27 Re: Updates on Views?
Previous Message Tom Lane 2001-03-23 04:05:17 Re: How to inspect blocked queries