Is it possible to write a SQL query that returns data translated into a different language on the fly — for example, data originally entered and stored in English, translated to French for a French user — the way Oracle can display its own UI components in different languages?

All FAQ questions / Developer Studio, deployment, and upgrades

Answer

No — Oracle's own language-parameter support (the mechanism that lets you view Oracle tooling/components in different languages) only affects how Oracle's own interface text is displayed; it has no ability to translate the actual data values stored in your tables. If a value was entered and stored as English text, it stays stored as English text — there's no query-level mechanism to translate stored data values into another language on the fly. Genuine multi-language data support requires the data itself to be captured and stored per-language at data-entry time (the way IFS's own translation mechanisms work for things like custom field prompts), not retrofitted at query time.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Developer Studio, deployment, and upgrades questions