Preparing a datamodel for internationalisation / localisation Post: 302735195

Sponsored Content

Special Forums UNIX and Linux Applications Preparing a datamodel for internationalisation / localisation Post 302735195 by figaro on Friday 23rd of November 2012 05:50:48 PM

11-23-2012

Registered User

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:

Code:

ALTER TABLE productprices CHANGE price price FLOAT COMMENT 'price of a product at any given moment'

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?

figaro

View Public Profile for figaro

Find all posts by figaro

8 More Discussions You Might Find Interesting

1. Solaris

book for preparing exam ?

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. UNIX for Advanced & Expert Users

preparing veritas exams using nextcertify.com ?

how good are nextcertify.com preps for veritas exams ? . i look forward to yoiur responses

3. Linux

Documentation for preparing RHCE certification

Hi all, Could someony give me a link to download a document for preparing linux RHCE certification? Regards, Tovo

4. UNIX for Dummies Questions & Answers

Script for reading filelist and preparing param file.

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...

5. UNIX for Dummies Questions & Answers

Resources for preparing exam certification

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...

6. AIX

AIX Monitoring Tool - under preparing

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...

7. Shell Programming and Scripting

Preparing a list of spawned processes

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...

8. Shell Programming and Scripting

Using localisation of a Perl package

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...

LEARN ABOUT DEBIAN

svn::web::i18n

SVN::Web::I18N(3pm)					User Contributed Perl Documentation				       SVN::Web::I18N(3pm)

NAME

       SVN::Web::I18N - SVN::Web internationalisation class

SYNOPSIS

	 use SVN::Web::I18N;			# Nothing exported

	 # Add a directory that contains .po and/or .mo files
	 SVN::Web::I18N::add_directory('/path/to/directory');

	 # Specify the current language
	 SVN::Web::I18N::loc_lang('en');

	 # Get a translated string
	 my $xlated = SVN::Web::I18N::loc('(a string to translate)');

DESCRIPTION

       SVN::Web::I18N provides the interface through which SVN::Web is internationalised, and how different localisations are implemented.

SUBROUTINES

   SVN::Web::I18N::add_directory($path)
       Adds a new directory to the list of directories in which localisations will be found.  Any *.po and *.mo files in this directory will
       automatically be scanned for localisations, and added to the language key given by the file's basename.

       In case where two different directories both contain a localisation file that defines the same localisation key for the same language, the
       localisation key from the most recently added directory will be used.

   SVN::Web::I18N::loc_lang($lang)
       Selects the language to use for subsequent calls to "loc()".  The $lang parameter should be a valid language name -- i.e., there must exist
       at least one $lang.po file in one of the directories used in a call to "SVN::Web::I18N::add_directory()".

   SVN::Web::I18N::loc($text)
       and

   SVN::Web::I18N::loc($text, $param1, ...)
       Returns the localised form of $text according to the localisation selected by the most recent call to "loc_lang()".

       If the localisation expects parameters to fill in the localisation result they should be passed as the second and subsequent arguments.

       If $text does not have a defined localised form it is returned with the parameters interpolated in to it.

SEE ALSO

       Locale::Maketext, Locale::Maketext::Lexicon, SVN::Web

AUTHORS

       Nik Clayton "<nik@FreeBSD.org>"

COPYRIGHT

       Copyright 2006-2007 by Nik Clayton "<nik@FreeBSD.org>".

       This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

       See <http://www.perl.com/perl/misc/Artistic.html>

perl v5.14.2							    2012-06-11						       SVN::Web::I18N(3pm)