Re: [GENERAL] Database design problem: multilingual strings

2003-06-24 Thread Dennis Gearon
In looking at your ideas, a thought came to mind. This issue is something I've been looking at neediing to address, so any comments are welcome. Whatever the first entry of a string entered becomes the reference string. You could add a field for that.The design below needs a unique index on:

Re: [GENERAL] Database design problem: multilingual strings

2003-06-24 Thread Ernest E Vogelsinger
At 19:15 24.06.2003, Antonios Christofides said: [snip] >'description' is no longer enough; it must be possible to add >translations to _any_ language and to any number of languages. >I've thought of a number of solutions, but none satisfies me to the >point

warning: long, Re: [GENERAL] Database design problem: multilingual strings

2003-06-24 Thread Karsten Hilbert
Hi ! We had this problem in GnuMed (www.gnumed.org). Eventually, we decided that it is only really solvable automatically for "fixed" strings. That is, strings that are known at database creation. User supplied strings need user supplied translations as well. The translation mechanism works for th