SQLite Forum

Language pairs strings how to
Login
Greetings.

I am planning a website to have both English and Spanish strings. These strings would be in SQLite. The idea is for a person to click on the language and be able to choose between the two languages and the website would populate on the chosen language. The question is what is the best way to do this? For example:

```
CREATE TABLE IF NOT EXIST Headers (H1, H2, H3);
```

This will take care of the English. I am stuck on whether I create a Headers_es (H1, H2, H3) also to address the Spanish language. I know there are probably many ways to do this, but, I would like some opinion from the experts. Any guidance would be greatly appreciated. Thanks.

josé