Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: One True i18n Table

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@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 - 07:08:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US