tags:

views:

41

answers:

1
Q: 

Using database for Internationalization & Localization

The CakePHP book has a section on Internationalization & Localization. Bascially what it says is Cake will generate a pot file and we have to create a .po for different language file from the pot file.

My problem is I want the user to be able to edit these localized text so instead of storing the localized text in the .po file I want to store them in the database.

So how can I store the localized text in the database?

+1  A: 

There's a Behavior for that.

Personally I find the TranslateBehavior to be rather inflexible though, so I usually just go with a separate table connected to the main model via a belongsTo relationship which contains all the translations. I then pick the one to display in the View.

deceze  2010-09-07 05:03:56
That sounds strange. The Translate Bahavior is for the model data. So I have to create a model to store all the labels that I use in my views. If I do it that way then I won't be able to use something like <?php __('Posts') ?> this anymore, right?
Sunny  2010-09-07 05:50:53
Yes, if you want to store user editable translations in the database, you need to use a model. At that point, your labels are not simply "translatable view elements", they're data like any other data in the database. `__()` will only look up translations in .pot files, so yes, you need to use something else.
deceze  2010-09-07 06:03:16

related questions

Does Tiles for Struts2 support UTF-8 encoded templates?
international characters in Javascript
Are you fluent in Unicode yet?
Don't repeat yourself vs Internationalisation
Stuts2 Tiles Tomcat suspected of changing UTF-8 to ?????
regex for parsing resource (.rc) files
Do you know of a good program for editing/translating resource (.rc) files?
Best javascript i18n techniques / AJAX - dates, times, numbers, currency
MySQL UTF/Unicode migration tips
Internationalized page properties in Tapestry 4.1.2
How do I put unicode characters in my Antlr grammar?
Are named entities in HTML still necessary in the age of Unicode aware browsers?
What is the "best" way to store international addresses in a database?
Local Currency String conversion VB6
Database backed i18n for java web-app
Internationalization in SSRS
Tool in Visual Studio 2008 for helping with Localization
Any good resources or advice for working with languages with different orientations? (such as Japanese or Chinese)
How can I refactor HTML markup out of my property files?
Handling timezones in storage?
Multiple languages in an ASP.NET MVC application?
Incomplete results with Turkish characters in Indexing Service
Internationalization in your projects
Localising date format descriptors
Floating Point Number parsing: Is there a Catch All algorithm?