Currently, I am storing a series of categories in a simple table.
Now I want to use / support other languages for display purposes. so, english will always be pulled from the db as the default language but I may need French or Spanish, for display purposes. its for a cms where I need it to be done in English (so I can manage it), but to be useable easily by people of other languages/nationalities.
create table categories ( category_name, varchar(99) not null primary key ) engine......
Now, I want to store >1 language. I think this is a series of 1:1 relationships.
eg ‘Vegetables’ (in English) is (I think), ‘Legumes’ in French.
I suppose my question is: how to tie the realtioships/values together?
create table categories ( category_default , category_french , category_german ) engine....
or maybe like this
create table categories ( category varchar(99) not null primary key , language char(3) NULL ) engine...
although the second thought doesn’t relate values of different languages so if I want the category of ‘carrots’, I may also need to get ‘carrotte’ but I’d be SOL with that structure.