Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: database localization , +
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 27-Sep-11 8:32am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
Comments
omid.amatour at 27-Sep-11 14:16pm
   
please check my comment, Do I true understand your mean?
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Your database design needs another change. Use NVarchar instead of Varchar, as it allows the use of unicode for characters.
  Permalink  
Comments
omid.amatour at 28-Sep-11 1:29am
   
oh yes
thanks for your reminder
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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.)
  Permalink  
Comments
André Kraak at 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)

  Print Answers RSS
0 Mathew Soji 274
1 BillWoodruff 270
2 Afzaal Ahmad Zeeshan 244
3 Sergey Alexandrovich Kryukov 240
4 Raul Iloc 160
0 OriginalGriff 6,219
1 Sergey Alexandrovich Kryukov 5,853
2 DamithSL 5,103
3 Manas Bhardwaj 4,549
4 Maciej Los 3,845


Advertise | Privacy | Mobile
Web04 | 2.8.1411019.1 | Last Updated 27 Sep 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100