Ok, I think this is a tricky one but who knows...
In an effort to create a multilanguage database, I set up the following.
I have a table with ids, called Items:
Now, I have another table with values, called Values:
So, as you can see, item #1 is available in english and dutch, item #2 in dutch only and item #3 in english only.
Now I have the following questions:
1. is this efficient? Is there a better way to do it?
2. I can request all items in a certain language by using a stored procedure that accepts a parameter for Language. But what if I wanted to make a stored procedure that accepts an id and a number of language preferences? So, let's say, I can tell the stored procedure to return item #2 in english, and if english does not exist in dutch, and if dutch does not exist in german, etc?
Hope you can give me some help!
Thanks,
Nander.
In an effort to create a multilanguage database, I set up the following.
I have a table with ids, called Items:
Code:
id other columns
====================
1 ....
2 ....
3 ....
Now, I have another table with values, called Values:
Code:
id Language other columns
==============================
1 english .....
1 dutch .....
2 dutch .....
3 english .....
So, as you can see, item #1 is available in english and dutch, item #2 in dutch only and item #3 in english only.
Now I have the following questions:
1. is this efficient? Is there a better way to do it?
2. I can request all items in a certain language by using a stored procedure that accepts a parameter for Language. But what if I wanted to make a stored procedure that accepts an id and a number of language preferences? So, let's say, I can tell the stored procedure to return item #2 in english, and if english does not exist in dutch, and if dutch does not exist in german, etc?
Hope you can give me some help!
Thanks,
Nander.