Disclosed are a method and system for enabling multi-language support for
data. A piece of data is captured and translated into a plurality of
languages. The original data and all of the translations are stored in
the same database instance, for retrieval and presentation in any of a
group of languages. The preferred embodiment of the invention provides a
design and implementation of generalized database tables to implement the
features of NLS Locales and NLS Text Groups, in order to enable the
storage and retrieval of dynamic, textual data in multiple languages,
concurrently, in a single database instance. The invention enables the
scenario wherein a piece of data captured in one language is dynamically
translated into all supported languages, and all translations are stored
in the same database instance, for retrieval and presentation in any of
the supported languages.