Database structure for creating Multilingual Applications RRS feed

  • Question

  • User2033318942 posted


     I am involved in development of a Multi-lingual web application that has now been targetted for English and Arabic. My proposed database design is like below

    Table Name : Language
    Lang ID Language
    en-US English-United States
    ar-BH Arabic-Bahrain
    Primary Key = "Lang ID"
    Table Name : Department
    Dept ID Description Lang ID
    1 Department of Environmental Studies en-US
    1 Department of Environmental Studies ar-BH
    Primary Key = "Dept ID + Lang ID"

    Can anyone please suggest whether this Database design is good and whether it is as per the International Standards with references?

    Please help

    Wednesday, November 22, 2006 5:39 AM

All replies

  • User-503940700 posted


    Check the last section of this article:


    Let me know if you have more questions.


    Friday, November 24, 2006 2:56 AM
  • User2033318942 posted

    Hi Vivek

     I came across the page you have suggested. It also follows the way in which i have designed my database. This is good.

    I had two options while designing this database structure.

    1. Having multiple columns for every culture.

    2. Having single column and adding culture id as part of the primary key.

    In the first part, database access is made too complicated when we go for multiple cultures. The second part sounds good for me. I am now in need to refer some internations standards that says about this database structure.

    Or else will it be possible for me to know how the database is structurally designed for the leading multi-lingual websites like Intel, Microsoft, etc.


    Sunday, November 26, 2006 4:46 AM
  • User-503940700 posted

    I think the DB design would vary as per individual project needs, so its best to go ahead with a design which suits your needs. Don't worry about any standards because there are no hard coded standards as such.


    Monday, November 27, 2006 4:01 AM