Leo,
There's another alternative that I found intriguing with MySQL that I
haven't tried - but it might be a really good solution for you. Mind you I
haven't tried this, but I found the idea somewhat fascinating.
Have you looked into the temporary table functionality of MySQL?
Suppose you have n tables with languages like this:
language_english
language_french
language_spanish
language_german
Now when you establish your connection to the database, do this:
create temporary table language select * from lang_english // pick your
lanuage in code
Now the rest of you code can refer to "language" as a table -- and you can
add as many languages as are needed modifying only the stub of code that
initially selects the language.
----- Original Message -----
From: "Leo Cambilargiu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March 18, 2001 8:30 AM
Subject: Tuple length Question
> Hello All:
>
> I am looking into mysql as a web solution. I am
> implementing a multilanguage scheme.
>
> I am considering separating the different languages by the
> following three methods.
>
> 1. Use different tables to hold different languages.
>
> 2. Use the same table with another key (lang).
>
> 3. Add extra attributes to a table and pick the ones
> containing the language I want.
>
> I am exploring possibility number 3 at the moment.
>
> My question is, how long can a Mysql myisam table tuple be?
>
> Currently I like the idea of increasing the number of
> attributes except for this possible constraint. I might
> have 6 to 10 languages supported max. I'll start with 2. I
> will have no more than 15 attributes total and possibly 5
> will be shared between languages. This means i'll have to
> add another 10 attributes per language implemented.
>
> Thanks in advance. Please email me at [EMAIL PROTECTED] or
> [EMAIL PROTECTED]
>
> Leo Cambilargiu
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php