| 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: | Whole Thread | Raw Message | 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!
| 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 |