Hi everybody, hi Kintzel.
If I had enough time to develop such a solution (for there are no problems, but only solutions;) ), i would only save references to resources in db instead of real text.
have a resource table with ids and optionally names. then have a language table with ids and optionally names. then have a table language_resources with resource id, language id and the real text.
in the table link in the column description you only have a reference to the id of the resources table.
then you can decide, whether you have a property, or let the user decide, which language to use. With the combination of language id and resource id you know the row of language_resources you have to fetch. simple criteria there.
But there is one factor you have to think about. This method is pretty time intensive. You can surely also use the internationalisation service (i18n) that comes with turbine, but i didnīt try that.
Good luck and have fun! kind regards Alex Hepp
T E Schmitz schrieb:
Kintzel Levente wrote:
This is important for a multilanguage application. Example: For a "link" on a linkpage I have a description in more than one language and the url. I want to store the description in several languages in such a way to be easy to maintain. Some design patterns for this problem? How to design the tables for this problem? (schema?).
Recently I came across Jakarta Commons Resources http://jakarta.apache.org/commons/resources/
The API provides access to JDBC Resources. I haven't had a close look at it, so I don't really know whether it is suitable for your application, but it might give you some ideas.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
