Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do you localize a database driven website

Tags:

People also ask

What is database localization?

Database localization is a very common task within the software development process. Many applications use databases to store language-specific information. The software globalization process must include database design adjustments in order to enable multilingual capabilities.

How is localization done?

Localization is the process of adapting a piece of content's full meaning for a new region, including translation, associated imagery, and cultural elements that influence how your content will be perceived. Localization is all about making your website feel like it was written with that audience in mind.


I've been playing with the .NET built in localization features and they seem to all rely on putting data in resx files.

But most systems can't rely on this because they are database driven. So how do you solve this issue? Is there a built in .NET way, or do you create a translations table in SQL and do it all manually? And if you have to do this on the majority of your sites, is there any reason to even use the resx way of localization?

An example of this is I have an FAQ list on my site, I keep this list in the database so I can easily add/remove more, but by putting it in the database, I have no good way have translating this information into multiple languages.