1

Preparing a datamodel for internationalisation / localisation

view story
linux-howto

http://www.unix.com – I have a database that should ultimately be included in a reporting engine. This will be a point-and-click setup whereby the user selects columns to include in the report and the users can run and save the report-script themselves. Users will have affinity with the data, but we want to design the system so that it becomes clear in the user interface what the user is selecting. To that end we want to use the column_comment feature in MySQL. We add column comments as follows: Code: ALTER TABLE productprices CHANGE price price FLOAT COMMENT 'price of a product at any given moment' Given (HowTos)