Sanity Check: L10N, PHP, and MySQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


I am currently working on a multi-lingual site that allows users to switch
back and forth between languages per page. Static elements, such as links
and headings, are handled nicely by 'gettext' and 'setlocale()'; dynamic
content, including form elements (country/city/category names), comes from
DB tables indexed by id/lang key pairs.

So far, so good. However, what's a good way to store and display a bit
more 'generic' content (ie., date; time; zip; phone #s) depending on
locale setting? Ideally, such values should be stored generically as INT,
TIME, DATE, TIMESTAMP, etc; and, after retrieval from the DBMS, formatted
according to locale.

Any pointers greatly appreciated.


Site Timeline