sql - Localize dbms demo data -

I am developing a windows mobile application that should work in many languages ​​(English, German, French, Russian).

This application is being shown to customers (German, Russia, ...) and we want to generate data based on that culture.

So: Is anybody thinking of a way to create data that is about putting in DBM at runtime? For example: For the English version, the VAT statement reads "VAT 17.5%" with the value 17.5

EDIT

I acknowledge that I was not very clear that I need a set of data so that the local To be done I need a system that reads "ready" localized data in any way and incorporates it into DBMS.

My second thought would be to use an XML file that has the same structure for all languages ​​(but the course is different values), such as

datafile.en-US. Xml

datafile.de-DE.xml

What do you think about it?

I do not know what your purpose is, so I can be wrong here ... by the way Also, if you are planning to distribute your Windows Mobile client application in different countries and one language version is to be worked in one country, I would recommend using resource files instead of SQL DB. You can enter messages such as "VAT {0}", "TVA {0}" and format them in a timely manner (depending on the programming language it will look different, please see C # below.) To valid cultural format Protect.

var vat = string.Format (vatPatternStringFromResources, vatValueFromResources.ToString ("P")); // "P" means the percentage format

If you still need to add the VAT value for the SX for reference, then you can simply add a decimal column which is the VAT table Either the foreign key will be maintained or just the VAT value ...

Update on different VAT values ​​

The problem is that, VAT values ​​only countries Not by itself, but according to what you buy ... so they are configurable There is a need to store properly ... Well, if you want to go with SQL DB, then you can use additional VAT tables spread in two columns with PK: a country ID (country table For the FK) and the other rated VAT rate for the country, both specific ...