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

    Unanswered: Database for website content

    Iīm building a database for my website, and I have around 30 languages to translate it to.
    I build a table for languages, and I want to relate content to it.

    Example:

    table languages
    language
    language_short (content example : EN)

    table navigation
    language_short (related, EN or CRO for croatian, depending on the row)
    logout (example : logout, "odlogiraj se" in croatian)
    signup
    jointhefans
    firstname
    surname
    email
    country (rel)
    city (rel)
    select gender
    month
    day
    year
    pleasetype
    doyouagree
    So you see the problem?
    How do I structure so many information without having to make so many collumns? How do I make it more simple, while I still structure the content into a logical database?

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    When I develop multi lingual applications I look at this in a different way. I use a concept of labels. So you start off with a label called FIELD. In english we would translate that into Field, in Spanish Campo, in French champs ... So my table structure is

    LabelName, LanguageID, LabelValue
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Jul 2011
    Posts
    4
    THX!! How could I have not seen that? xD

Posting Permissions

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