I have many tables with attributes.
All this attributes should be translated in 5 languages and attributes are wrote by the client.
How can I do for store the translations ?
Should I use spliter in the attributes?
E.g* :
[en:] my name is marouane [fr:] je m'appelle marouane ...
Should I use for each table a new table with new attributes named (id_language) foreign from table language , each language have row
E.g :
|_________________________|
|fr|je m'appelle marouane |
|en|my name is marouane |
or with XML files ? E.g :
<table>
<row lang="fr">
<cell>je m'appelle marouane</cell>
</row>
<row lang="en">
<cell>my name is marouane</cell>
</row>
</table>