Re: One True i18n Table

From: Kenneth Downs <firstinit.lastname_at_lastnameplusfam.net>
Date: Fri, 15 Oct 2004 08:08:39 -0400
Message-ID: <6keokc.sif.ln_at_mercury.downsfam.net>


--CELKO-- wrote:

>>> I am wondering how others have approached this. <<

>
> If we are talking about the same thing, use SQLSTATE and attach
> various languages to each code in a single table:
>
> CREATE TABLE ErrorMessages
> (err_msg_code CHAR(5) NOT NULL PRIMARY KEY,
> english_err CHAR (25) NOT NULL ...
> french_err NCHAR (25) NOT NULL ..
> ...
> esperanto NCHAR (25) NOT NULL ..);

ouch. The above requires a structure change to add a language.

-- 
Kenneth Downs
Use first initial plus last name at last name plus literal "fam.net" to
email me
Received on Fri Oct 15 2004 - 14:08:39 CEST

Original text of this message