hi everyone,

Our development team has been thinking about storing mutlilanguage product data in a database. We are thinking about two ways of mapping Locale data to the database:

1. With an seperate LocaleData object, which maps to its own table.
2. The localized data is stored in one string. This is added in a varchar to the table.

The object would look somewhat like this:

Product:
- int getId();
- String getTitle(Locale l);
- String getDescription(Locale l);

The first would be neater normalization-wise. The second, though quite ugly, is faster, since a join operation on two huge tables takes a lot of time. What kind of approch would you use? I'd like to know what other people used as a solution. I'm here to learn :)

Thanks,
Vincent

there's a blog from gavin about i18n. don't know if you've allready found it ..

http://blog.hibernate.org/cgi-bin/blosx ... 06/23#i18n

gtx
curio

Thanks for the link, I have not seen that one before. The suggestion Gaven King uses to internationalize labels is good for user interfaces, but not very helpful for large databases in which each product has multiple properties with internationalized text. I'm looking for a solution that is able to handle huge amounts of information.