nclob_ext

Description

Normally, NCLOB data is stored as binary in UTF16 format. When nclob_ext is set, the Oracle connector stores NCLOB data in the Unicode format, in accordance with the National Character Set defined in the Oracle database. This makes it possible for the NCLOB data to be processed by non-Uniface tools, such as SQL*Plus.

The National Character Set is an alternative character set that enables you to store Unicode character data in a database that does not have a Unicode database character set. For more information, consult the Oracle® Database Globalization Support Guide.

Note:  We recommend that you use the nclob_ext connector option when working with NCLOB fields. However, to do so, you need to migrate the data.

To migrate the data so that you can use the nclob_ext connector option:

1. Export the data from Uniface to XML files.
2. Delete the data in database.
3. Edit the assignment file to add the nclob_ext option to USYS$ORA_PARAMS
4. Import the Uniface export containing your data.