> > > Hi. > > I'm investigating ways to support multiple languages in my > app, without using the typical > ResourceBundle/MessageResources approach. I was thinking that > I would like to use a database instead. It seems to me that a > large application trying to support multiple languages with > this approach might become a real maintenance issue. > > What I'm interested in is three things: > > 1.)Any opinions on whether this does in fact create > maintenance issues (I've yet to write a large, i18n app). And > what are the ways to mitigate some of these issues.
I would imagine that the maintenance problems would be similar to those of storing in a properties file, the only problem being that you now won't have standard tools to check for missing keys. However having said that, a database query to do the same would be extremely simple. > > 2.)Is anyone using a database-driven approach to this, > storing application labels, etc. in tables and retrieving > them. Possibly, by reimplementing versions of > ResourceBundle/MessageResources to go against tables. You'd > still have to update entries manually but I kind of like the > idea of putting this info in the database. We would like to try this approach as we are currently writing a large i18n application, but currently our database doesn't support this, so it would be interesting to see how you go? > > 3.)I know that some databases, Oracle, and I hear the newest > version of MySQL support UTF-8. I've no experience in this > area. Does anyone have experience with storing text in UTF-8 > in the database? This *seems* like it could be an ideal > approach, eliminating alot of on-going work. Obviously, the > app would be less portable. Also have you considered performance? Accessing the database a lot could be quite expensive, especially for something like message resources, so you would probably have to implement some kind of caching strategy. How often do you expect to change values, could you store values in a DB and generate your properties files from it on a daily basis for instance? > > If anyone has suggestions/comments on any of the above, I've > love to hear them. > Hope these help Simon --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
