SQLite Forum

Language pairs strings how to
Login
I don't think there is one solution which I could recommend in all cases.  It comes down to different levels of data.

A) You could make two different database files. One has the strings in English, one in Spanish.

B) You could make one database with two tables: one table with the English strings, one with the Spanish strings.

C) You could make one table but have two different rows for each purpose: one row has the English strings, the other row has the Spanish strings.

D) Or you could have both languages in the same row:

<code>CREATE TABLE IF NOT EXIST Headers (HE1, HE2, HE3, HS1, HS2, HS3);</code>

Part of it is about whether you might add another language to your solution.  For instance, if you might eventually add another language, you would not want to use the HE1, HS2 solution because making the changes would be tedious.