My Oracle Support Banner

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

Last updated on DECEMBER 19, 2019

Applies to:

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


Symptoms

Forms 10.1.2.0.2 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.

Cause

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
Symptoms
Cause
Solution
References

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