that defines the content and groups it, e,g,
ContentID, Content Type,
Then you have a relationship to another table which is the join of
press releases so you group them all as one:
contentID, PRID
This has now linked it to a lot of press releases that can be in
different languages (and versions) and you get the latest for that
language for the content ID
so you have the root contentId as the unique identifier for a content
and you then can associate it with another version.
Sorry if its a bit mixed up but I am still waking up!
MD
On Mon, 20 Sep 2004 09:46:04 +0100, Ian Vaughan
<[EMAIL PROTECTED]> wrote:
> If for instance you have the following example table containing Press
> Releases in English
>
> PRID
> PRTITLE
> PRSUMMARY
> PRBODY
> PRPUBLISHDATE
> PROWNER
>
> How would you make this multilingual ?
>
> Would you create other tables for French, Italian etc ??
>
> or would you just add a PRLANGUAGE field to the above table ?
>
> And how would the relationship between the PRID's for example work for
> different languages ?
>
> ________________________________
>
> From: Paul Hastings [mailto:[EMAIL PROTECTED]
> Sent: 17 September 2004 16:16
> To: CF-Talk
> Subject: Re: Content Management System (CMS) Wishlist
>
> > for multilingual content = not just creating a separate branche for
> > other languages.
>
> yeah that was the first thing folks suggested when we started discussing
> this for farcry. i'm not for that technique (1 new language = 1 new
> site).
> we'll see how this plays out w/farcry.
>
> > Creating a system being able to handle multilingual content, on object
> > bases, is not a simple task.
>
> perhaps but i've known it to be done ;-)
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
