translate tab mysteriously appeared...
Posted: Thu Sep 01, 2011 4:23 amHaving a table called 'accounts' and a view called 'accounts_vw' brought about an interesting side effect today..
"For each table that needs to be multilingualized, add corresponding tables of the form Tablename_<lang-code> (where <lang-code> is the 2-letter ISO 639.2 language code). E.g. If the table 'Profiles' needs to be translated into English and French, you would create tables named 'Profiles_en' and 'Profiles_fr' with primary key columns and columns that need to be translated. These tables need not contain any columns that don't need to be translated (e.g. Phone Number)."
For now I've just modified my view naming scheme, but it took me a while to figure out "the why"
cheers,
-Barry
"For each table that needs to be multilingualized, add corresponding tables of the form Tablename_<lang-code> (where <lang-code> is the 2-letter ISO 639.2 language code). E.g. If the table 'Profiles' needs to be translated into English and French, you would create tables named 'Profiles_en' and 'Profiles_fr' with primary key columns and columns that need to be translated. These tables need not contain any columns that don't need to be translated (e.g. Phone Number)."
For now I've just modified my view naming scheme, but it took me a while to figure out "the why"
cheers,
-Barry