|
|
Posted by CAH on 11/15/14 11:27
I once wrote on usenet and got a very good answer . This one
JN 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';
>
which I used, and it works just fine, except that I just discovered
that if I place just a litle more than a few line of text - in the TEXT
fields then i get an "error" in phpmyadmin. There is a small question
mark were thre is normally a pen and a cross - and when I move the
cursur above the question mark i get this. "you should define a primary
key for this table" .
Do you have any suggestions as to what the problem might be?
Thanks for any help you can offer.
Best regards
Cah
Navigation:
[Reply to this message]
|