My Oracle Support Banner

Character Set Problems with CLIENT_TEXT_IO versus TEXT_IO (Doc ID 352187.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Forms - Version to [Release to Oracle10g]
Information in this document applies to any platform.


Forms with WebUtil 1.0.6.

Text stored in the database must be put in a file on the client PC.
The resulting file needs to be encoded in OEM, therefore character set WE8PC850 is used in a convert(...) command.

For this, WebUtil's client_text_io is used, with the following conversion:
client_text_io.put_line(outfile, convert(test_rec.test, 'WE8PC850', 'WE8MSWIN1252'));

For different databases with different database character sets, the results are not the same.
One result is OK; the other result is incorrect.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.