| The basic principle of table localization is to isolate all of the localizable columns and create a new localizable table for each language. Localizable table can be either a clone or subset of the native table.
Clones of the native table
Each localized table will contain All of the data contained in the native with localized data instead of native. Subsets of the native table
each localized table will contain ONLY the localized columns data plus as many extra columns as those contained in the primary index of the native table.
In both cases the localizable table MUST contain the localizable columns. The choice is dependent on the data your database contains. |