I am trying to use a previously created database following the tutorial:
http://www.reigndesign.com/blog/using-your-own-sqlite-database-in-android-applications/
I plan to use the database for storing questions for a trivia-like game. With the basic design of one table:
CREATE TABLE QUESTIONS (
answer TEXT, --text for answer
create_by_user NUMERIC, --boolean flag, true if question created by user
_id INTEGER PRIMARY KEY, --required by Android
l10n TEXT, --ISO 3-letter code for localization
question TEXT --text for question
);
And using the field l10n for l10n/i18n purposes, but I am not sure about how Android uses android_metadata
table. In the tutorial a row with "en_US" value is inserted,
- Is this table a sort of built-in l10n used by Android?
- It would be advisable to use the table android_metadata for l10n instead of my own l10n field?
- What if I want the database to store different languages data and to give the option to the user to retrieve questions from different languages?
- Do I need or is it better to have one database per language?