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 184.108.40.206.1 to 10.1.2.0.2 [Release 220.127.116.11 to Oracle10g]
Information in this document applies to any platform.
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.
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