Click here to Skip to main content
15,867,594 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi to Experts

I want to design a DB for several language, but I have question?
In This DB there are user information that saved to several languages.
for example:

UserID, FirstName, LastName, Biography

How to I design it?

thanks a lot
Posted

I can't imagine you mean things like first name and last name would be localized. For columns such as biography you would need to create another table with columns such as; Id, lcid, text, where I'd is of course the identifier for this table, lcid is the language code and text is the localized text. Then create a join table between this and the user table and select based on the lcid to get the localized text needed.
 
Share this answer
 
Comments
omid.nazifi 27-Sep-11 14:16pm    
please check my comment, Do I true understand your mean?
Your database design needs another change. Use NVarchar instead of Varchar, as it allows the use of unicode for characters.
 
Share this answer
 
Comments
omid.nazifi 28-Sep-11 1:29am    
oh yes
thanks for your reminder
You are telling me that I design the database as follows:

CREATE TABLE UserName(UserID int IDENTITY PRIMARY KEY NOT NULL)



CREATE TABLE Language (LanguageID int IDENTITY PRIMARY KEY NOT NULL,

LanguageDescription varchar(50) NOT NULL)





CREATE TABLE UserAttrib (UserID int NOT NULL FOREIGN KEY REFERENCES UserName(UserID),

LanguageID int NOT NULL FOREIGN KEY REFERENCES Language(LanguageID),

FisrtName varchar(100) NOT NULL,

LastName varchar(100) NOT NULL

--etc.)
 
Share this answer
 
Comments
André Kraak 27-Sep-11 15:03pm    
If you have a question about or comment on the given solution use the "Have a Question or Comment?" option beneath the solution. When using this option the person who gave the solution gets an e-mail message and knows you placed a comment and can respond if he/she wants.

Please move the content of this solution to the solution you are commenting on and remove the solution. Thank you.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900