Sanity Check: L10N, PHP, and MySQL

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Michael Ruebner

    Sanity Check: L10N, PHP, and MySQL

    Greetings,

    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.

    Mike
Working...