multilangual problem

Hello,

yeah i know this would not be kind of question which belongs in this newsgroup, but i am working with Oracle and i am just having this major problem.

within my project i need to set up reports which are multilangual. The languages Dutch, English, German and French are the languages reports are printed.
The report it self contains technical measurements and has a general section containing just clientspecific information.

Now i want to do, because not all reports are the same, i want all the words and sentences which are general and standard in the report stored in my oracle database. now i have no idea what is the best workaround on storing multilangual information.
I mean the table-layout. You can devide this report in several categories.

I was thinking in several solutions:
1. only one table containing an IDLNG and the FIELDS: IDCAT, NL, GE, UK, FR  and a Category table having IDCAT and CAT 2. per category a language table

I hope you understand my problem. for an example you can think about like a word 'Page'
a dutch report would print: 'Pagina', an english would print 'Page' , etc.

how do you solve this problem; i am a little bit confused.

cheers,
Danny Received on Sun Feb 16 2003 - 01:54:57 CST