mysql多语言运营设计,如何设计多语言数据库？

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

解决方案

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.

Your database design needs another change. Use NVarchar instead of Varchar, as it allows the use of unicode for characters.

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.)