I'm trying to do pretty much the same --- and want to know if anyone out there has experience with multi language mgmt- especially the pitfalls to be avoided. The page in question on my site that needs to support 5 languages is primarily images and little text. But most of the text is derived from the database (drop-down menu content etc) and my idea right now is to put my translations in different columns in the same table. Depending on the user's language settings (known from CGI variable HTTP_ACCEPT_LANGUAGE)- I could substitute info from the appropriate column- and then cache the page.
The shortcoming of this system seems to me to be 1. Static text (HTML)- I could probably create 5 different HTML code snippets in each language and load those the same way. 2. Maintaining translations for each table of concern- Maybe an alternative could be a separate table that has english keywords with their translations and I could a search on a list/structure of english-to-some-other-language key-value pairs. That way I could separate the actual queries from the translation itself. Any thoughts, criticisms, words of wisdom and/or encouragement welcome Thanks, Nik [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
