Preparing a datamodel for internationalisation / localisation
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:
Given the flat nature of a database, this does not allow for expressions. For example, we would want to prepare the database for translations (localisation), that would in procedural languages be done using gettext for example. What would be the best way to maintain translations of column comments?
On an early version of a utility CIS in oracle 6, we had to have separate schemas - One for Spanish, another for English. There too many side effects otherwise.
We published two data dictionaries one for Spanish, one for English, to a special set of tables we used for prompting. We did not use comments. We used two sets of synonyms that had descriptive table and field names. Base sql code was unaffected by this.
Thank you for your response. We thought it was going to go that way. It looks like the work load for both development and changes is not going to be affected by this all that much, even if expressions were allowed.
I have a Perl package, which is widely used and tested, but recently a version in another language was added. The relevant po-files have been reviewed for this and are ready for testing. What are the steps to select the language by the user? From my understanding the language environment variable... (3 Replies)
Hi All
I'm currently trying to develop a script which will find the child processes of a process ID already passed to the script.
I then need the script to look for spawned processes of these child processes and so on until it can't find any more.
For example
At the moment, I have to... (6 Replies)
Guy's
AIX Monitoring Tool - under preparing .....
I'm working to make and prepare tool to monitor AIX system and my idea it's based on the following outputs
I want command to give me shout outpous about the following ...
CPU load
Memory load
Used load
Number of... (5 Replies)
I had install Sun Solaris 10 in my virtual machine. Anyhow I still very limitation knowledge how to operate it. Would like to search for help somemore could assist me how could I get the resources by free for me to learn and prepare myself for sitting the Sun cerfitication exam?
Please help and... (3 Replies)
Hi All,
Not sure if this would be in a dummies sectiin or advanced. I'm looking for a script if someone has doen something like this.
I have list of files -
adc_earnedpoints.20070630.txt
adc_earnedpoints.20070707.txt
adc_earnedpoints.20070714.txt
adc_earnedpoints.20070721.txt... (2 Replies)
dear solaris group,
whitch are the best book for study admin 1 + 2 on solaris 9
to prepare for the exam of admin 1 & 2
best regards
Maurizio (2 Replies)