Posted by Jeff North on 06/28/05 10:22

On 27 Jun 2005 23:54:43 -0700, in comp.lang.php
"madsgormlarsen@gmail.com" <madsgormlarsen@gmail.com> wrote:

>| Should one place all the text in one big table, or is i better to place
>| it in several tabels. Should one make 4 colums one for each language,
>| or 4 rows one for each language?

I use:
CREATE TABLE `usr_languages` (
`pageName` varchar(25) default '',
`itemNo` int(11) default '0',
`en` text,
`fr` text,
`it` text
) TYPE=MyISAM COMMENT='different languages';

only because I can immediately see if I have not include text for a
particular language and a particular entry.

pageName: which page this text appears on
itemNo: order of items to be read and placed on page.
en/fr/it: the different languages.

I haven't optimised this as yet so the 'text' field is probably
overkill and a varchar(255) would suffice.
---------------------------------------------------------------
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

[Back to original message]