For sure, an all-encompassing post topic!
We are building a web-based travel portal in PHP/MySQL which will be 'ported' to other languages and time-zones in the future, to be used by joe-public and by travel agency staff.
At present we are developing locally on WAMP, with the publicly accessible setup to be LAMP using Apache 1.3, PHP4 and MySQL4.1.
Having read around the subject of char-encoding In order to properly cope with multi-language data we will probably then:
Presently however we have no such comprehensive measures for time, date and currency (locale settings) for when the system is ported to other countries. (The location of the host may be changing according to the country, the language and currencies of its users will need to change).
- send XHTML headers as UTF-8
- encode & store DB data as UTF-8
- send POSTed form-data as UTF-8
- possibly make use of the mbstring library?
Ideally we'd like to be able to tweak a few constants and vars in a custom PHP config script and the system would be ready to go in its new locale.
The likelyhood of required support for languages such as Chinese variants, Korean and Japanese is unlikely but if the support for these could be be fairly easily built-in at the outset, then all the better.
I'd like to know what techniques you guys might have used or are using right now in the development of multilingal and multi-locale PHP/MySQL websites and web-apps.
Thanks a lot for any ideas you all might have