RE: internationalizing text

I think that the standard way to do this is to use a resource identifier,
and then have a separate table with all strings. That's the way that most
internationalisation is done in programs, and it's probably not bad for
databases either.

So maybe:

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

Anyway, just a thought...

MikeA

-----Original Message-----
From: will trillich
To: pgsql-general(at)postgresql(dot)org
Sent: 23/03/01 04:06
Subject: [GENERAL] internationalizing text

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!

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

_________________________________________________________________________
This e-mail and any attachments are confidential and may also be privileged and/or copyright
material of Intec Telecom Systems PLC (or its affiliated companies). If you are not an
intended or authorised recipient of this e-mail or have received it in error, please delete
it immediately and notify the sender by e-mail. In such a case, reading, reproducing,
printing or further dissemination of this e-mail is strictly prohibited and may be unlawful.
Intec Telecom Systems PLC. does not represent or warrant that an attachment hereto is free
from computer viruses or other defects. The opinions expressed in this e-mail and any
attachments may be those of the author and are not necessarily those of Intec Telecom
Systems PLC.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
__________________________________________________________________________