[Catalyst] Multilingual Site

[Michael Schreier]

That sounds great and I'll check this for my template work, but now I 
have an additional question.

What about user generated content? For example: I have a site with three 
languages "en,de,fr" and the user can make input in one or all of these 
languages.

Is it ok, if I have a row in the DB for each language?

Table article:
id, year, month, author, ...

Table article_content:
article_id, language, content
1, de, hallo
1, en, hello

Or is there a better way to do such things? Other table structure?

The solution to have each language in a seperate column sounds like 
"high-maintenance" to me, if I need a new language.

And how is the best way, to fetch multilingual content with DBIx::Class?

What is your know-how there?

Thanks
Michael

Yuval Kogman schrieb:
> On Tue, Feb 19, 2008 at 19:07:05 +0100, Michael Schreier wrote:
>   
>> I want to create a "Multilingual Site", but I don't know how to begin, 
>> especially with catalyst.
>>     
>
> Basically it comes down to using a localization engine for all text.
>
> How you do that is up to you.
>
> Catalyst's I18N plugin provides DWIM to choose the right language
> based on the headers, and eventually delegates to Locale::Maketext.
>
> I'd read this article thoroughly:
>
> 	http://search.cpan.org/~jhi/perl-5.8.1/lib/Locale/Maketext/TPJ13.pod
>
> at which point things should become clear to you.
>