Multi Language Support
417192May 21 2004 — edited May 27 2004Hi,
I am investigating the best practice/approach for multilanguage support. We have european and chinese users.
Here (briefly) is what I would like to do
SELECT colx "alias"
FROM T
WHERE coly = :a
If I am servicing an english user then the alias string might be something like name, address, tel etc.
If I am servicing a chinese user then alias might be something like 名字 etc....
In other words I want reports with english columns for english users and chinese columns for chinese
users.
It would be nice to store different versions of the same SQL statement in a table and do the following:
SELECT q INTO vc_query FROM app_queries WHERE lang = 'Chinese'
then return the SQL statement OR
EXECUTE IMMEDIATE vc_query USING IN vc_constraint INTO c1, c2 etc....
Another related issue: what is the best practice for setting NLS..... on the fly ie. when the user
is authorised ?
Any advise, best practice appreciated.
best regards,
Mark Battersby
email: mark.battersby@ctseurope.cn