April 21, 2010 at 7:18 pm
The app I am developping should support two languages (English and French). For some tables, I need to store both value. By exemple I have a "Status table". I have designed this table with 3 columns, please tell me if there is a better way
ID_STATUS INT NOT NULL PK
STATUS_en varchar(30)
STATUS_fr varchar(30)
Now I need to extract the data to show the status in a combobox. Depending of the user authentication language, I will display either the English values or the French values.
There is several way to to this.
- Build the SQL statement within my app
- Use a store proc, extact both values and my app will use only one
- use a store prod, using a parameter to get the language and having a "if" in the stored proc
- anything else?
What would be the best pratice for a multi language table like my status table?
thank you
Martin
April 21, 2010 at 11:14 pm
Hi,
I would use the stored procedure (separate from the application in a database) and pass the language selected as a parameter from the application. in this way it is easier to maintain a stored procedure
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply