METHOD AND STRUCTURES TO ENABLE NATIONAL LANGUAGE SUPPORT FOR DYNAMIC DATA

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.