Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    4

    Question Multi-lingual Database Design

    Hi

    I am working on a multi-lingual web application. This application will provide the search facilty to data related to products in different languages according to the clients locale information.

    There are different approaches i have identified to store the multilingual data each have its own good and bad points.

    i.e

    One table per language
    One column in table for each language
    One row containing the data in each language with the language id

    I want to have a good advice for it so that in future this design will help me for maintinance and w.r.t response time.

    I will wait for your quick response.

    Best Regards

    WAK

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    I've done the language ID portion, e.g.

    ErrorCode( Code, Lang, Message )
    where:
    { 'Err1', 'EN', 'You broke it, dummy!';
    'Err1', 'FR', 'Parlez-vouz dummy?' }

    The primary key was Code, Language.
    Thanks,

    Matt

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: Multi-lingual Database Design

    Originally posted by wajid
    Hi

    I am working on a multi-lingual web application. This application will provide the search facilty to data related to products in different languages according to the clients locale information.

    There are different approaches i have identified to store the multilingual data each have its own good and bad points.

    i.e

    One table per language
    One column in table for each language
    One row containing the data in each language with the language id

    I want to have a good advice for it so that in future this design will help me for maintinance and w.r.t response time.

    I will wait for your quick response.

    Best Regards

    WAK
    Of the 3 approaches, only one allows for addition of further languages without having to create or alter tables - and therefore, without having to modify your application code either. That is the 3rd option with the row per language. The additional condition on queries ("and language_code=?") should not impact performance significantly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •