Professional Web Applications Themes

additional table (for languages purposes) - MySQL

hi, i need an advice related to creating a table besides the ones that i already have... i need to store information in another language out of some tables... and i have a special table that has about 25 fields.. so if i add some others.. there will be sort of 35-40 fields in one table.. is this normal? would you suggest me to create another aditional table in which i create just the additional fields that i need in another language? thank you...

  1. #1

    Default additional table (for languages purposes)

    hi,

    i need an advice related to creating a table besides the ones that i
    already have... i need to store information in another language out of
    some tables... and i have a special table that has about 25 fields..
    so if i add some others.. there will be sort of 35-40 fields in one
    table.. is this normal?

    would you suggest me to create another aditional table in which i
    create just the additional fields that i need in another language?
    thank you

    joxy Guest

  2. #2

    Default Re: additional table (for languages purposes)

    On 12 Jul, 16:04, joxy <com> wrote: 

    I don't understand why another language should require more fields?

    A field should be for an element of data. A field for "Description"
    holds the description, regardless of whether that description is
    written in English or Spanish.

    Captain Guest

  3. #3

    Default Re: additional table (for languages purposes)

    On 12 Jul, 16:04, joxy <com> wrote: 

    Oh I didn't answer your other questions:

    Is it notmal for a table to have 35-40 fields in it. It is normal for
    tables that have 35-40 fields in them, to have 35-40 fields in them.
    In the same way as it is normal for tables that have 5-10 fields in
    them to have 5-10 fields in them. There is no "normal", there tends to
    be only too many.

    Depending on the sort of data held in the table, I would suggest
    having a language field and storing the records in the same table or
    splitting off the multilingual fields into a separate table with a
    foreign key.

    Captain Guest

  4. #4

    Default Re: additional table (for languages purposes)

    thank you

    the languages that are in the fields that i am talking about are not
    switchable... i mean i need to have and show the same information in
    both en/sp. this related to your advice of having a field describing
    in which lang. the info is..





    On Jul 12, 10:41 am, Captain Paralytic <com> wrote: 


    >
    > Oh I didn't answer your other questions:
    >
    > Is it notmal for a table to have 35-40 fields in it. It is normal for
    > tables that have 35-40 fields in them, to have 35-40 fields in them.
    > In the same way as it is normal for tables that have 5-10 fields in
    > them to have 5-10 fields in them. There is no "normal", there tends to
    > be only too many.
    >
    > Depending on the sort of data held in the table, I would suggest
    > having a language field and storing the records in the same table or
    > splitting off the multilingual fields into a separate table with a
    > foreign key.[/ref]


    joxy Guest

Similar Threads

  1. for tutorial purposes.....network
    By ehabaziz2001@gmail.com in forum Linux / Unix Administration
    Replies: 3
    Last Post: April 8th, 01:07 PM
  2. Replies: 3
    Last Post: September 4th, 09:44 PM
  3. Setting up IIS for DHTML purposes
    By ellipses webforumsuser@macromedia.com in forum Macromedia Dynamic HTML
    Replies: 0
    Last Post: November 11th, 02:03 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139