Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011
    Posts
    4

    Site with dfferent languages. ERD?

    Im building a website that will be translated into 10 different languages. The database contains alot of attrubutes with text such as book title, book review, book description etc etc.

    What is the best sollution for this when it comes to designing the database? Will each attribute have "duplicate" attributes for all the different languages?

    Example (sorry for my ugly drawing):

    _____
    |----|----English_book_title
    |Book|
    |----|----Spanish_book_title
    |____|

  2. #2
    Join Date
    Apr 2010
    Location
    London, England
    Posts
    24

    Yes, store multiple versions

    This Data Model on my Database Answers Web Site shows you a simple example :-
    Foreign Language Tournament Listings Data Model

    You can see that the Language ID is part of the Primary Key in the Tournaments Details Table, which means that a separate description can be stored for each language.

    HTH

    Barry Williams
    London, England

  3. #3
    Join Date
    Aug 2011
    Posts
    4
    Thanks alot Barry! Appreciate it!

Posting Permissions

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