Character Set Problems with CLIENT_TEXT_IO versus TEXT_IO
(Doc ID 352187.1)
Last updated on OCTOBER 07, 2023
Applies to:
Oracle Forms - Version 10.1.2.0.2 to 10.1.2.3.0 [Release Oracle10g to 10.1.2.3]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 |