varchar2_4k
Map Uniface character fields (with a C packing code) from 256 to 4000 bytes to Varchar2.
USYS$ORA_PARAMS = varchar2_4k
Use
This option applies only to the U6.x connector and above. It has no affect on older connector versions.
Description
By default, the Uniface Oracle connector maps Uniface characer fields from 256 to 2000 bytes in length to the Oracle Varchar2 storage format, and fields that use the Wide Character packing code (W) to NVarchar2. Fields that exceed this length are mapped to Clob or NClob.
By setting varchar2_4k, you can extend Uniface's use of Oracle Varchar2 storage to Uniface character fields that are up to 4000 bytes instead of 2000 bytes in length. This setting has no effect on fields that use the wide Character packing code (W). They are mapped to NClob if the exceed 2000 bytes.
When set, Uniface maps character data as follows:
Uniface Packing Code |
Oracle Data Type |
---|---|
C1-C255 |
Char |
C256 to C4000 |
Varchar2 |
W256 to W2000 |
NVarchar2 |
C4000 - C* |
Clob |
W2000 - W* |
NClob |