translate tab mysteriously appeared…

Archived from the Xataface Users forum.

barryrs — Thu Sep 01, 2011 4:23 am

Having 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_ (where 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