Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2008

    Question Unanswered: Multilanguage fields - design question


    I’m currently writing an application that will be used in more than one language and would like to get some advice concerning a good way to handle multilanguage entries in the database schema.

    See the attached images:

    version1.jpg from here

    and version2.jpg, my own design.

    Both ways have their weaknesses/benefits…
    In both approaches the language dependent data is factored out into separate tables - in version1 there is a table for every entity that holds the translations and in version2 one table that holds all strings and one that holds all translations.

    Any experience with something like this?
    What would you recommend?

    PS: I have asked this question also in CodeIgniter Forums
    Attached Thumbnails Attached Thumbnails version1.jpg   version2.jpg  

Posting Permissions

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