Re: Multilanguage application & database

From: HansF <news.hans_at_telus.net>
Date: Mon, 25 Oct 2004 14:43:51 GMT
Message-ID: <Hi8fd.5$df2.1@edtnps89>

K wrote:

>> When you say "tables in the database with fields" .... are you referring
>> to
>> "columns"?  (For me, field is something on a screen to be handled by the
>> front-end, just like Oracle Discoverer's EUL.)

>
> Sorry- RECORDS have fields, TABLES have columns -my mistake.
>

>> If that is the case, and if you are concerned with the column name (not
>> the contents), have you considered using language-mapping views to
>> overlay the table and 'rename' columns to the appropriate language?

>
> If you looked at the examples, you'd see that I wanted to translate
> contents. Thanks anyway,

I glanced at them - the layout was confusing so I decided to ask rather than reformat. (I'm easily confused <g>) Apologies ...

I suspect if there was an easy way, you would get an easy answer. If you look at Oracle's solution - restricted to their error messages - you would note they have a set of secondary files (but you could use tables, if you wish) that contain the translation info.

In addition, there is a lot of work going on in the I18N community. You might get more info there. You might check whether there is anything recent at http://www.i18ngurus.com/ to help.

/Hans Received on Mon Oct 25 2004 - 09:43:51 CDT