On 10/2/2012 4:01 PM, Edward Chanter wrote: > We're about to embark on a project for which locallisation is a requirement > and it's the first time I've done this. I understand the basic concepts > about having data containing the words and phrases needed on a website > stored with versions for each language but I'm trying to figure something > out: what's the best way to store the data?
i think the question should be "what's the best way manage all that data"? typically, this won't be a one off, you'll need to manage translations for a growing number of locales & the stuff being translated is likely to grow in complexity (if its not already). who's doing the translations (hint, unless its an app about IT, it really shouldn't be your developers)? dealing w/professional translators, especially for "exotic" subjects, is often a "herding cats" exercise. you'll need something to keep track of what's been translated, when & by whom. will the translated resources need to be shared w/other platforms? for java, which has had i18n bits since forever, it's normal practice to use resource bundles (rb) & manage these w/one of the popular rb tools like rbManager or Attesoro. that's not to say can't mix database supplied text & rb. massive amounts of text probably should be in some sort of database but you'll need the same kind of tracking mechanism as "regular" rb tools. and just to make sure its clear, localizing an app isn't the 1st step. its internationalization (i18n)--besides the text, your app will need to handle date,time,number & currency formatting per locale. maybe calendars (not everybody uses gregorian calendars) as well as timezones. layout (LTR vs RTL locales), colors & even graphics all play a role in localization. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352806 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
