android: multi language database issue
<p>world! I am developing an Android project for my Android course at university. I am creating an app about my country. So a user will be able to view our national food, instruments etc. I cannot figure out a good approach for creating a table so that it supports multi languages in android SQLite. My solution for food table: </p>

<p><strong>ID</strong> Primary key</p>

<p><strong>Food_name-def</strong> VARCHAR(100)</p>

<p><strong>Food-name-ru</strong> VARCHAR(100)</p>

<p><strong>Food-desc-def</strong> TEXT</p>

<p><strong>Food-desc-ru</strong> TEXT. </p>

<p>Is this a good approach for suuporting multi languages for each table(food, instruments etc)?</p>