Purpose
Allows you to set the system default for the export width of a character in bytes.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| 0 - Expected defaults | Provides reasonable default widths for the character data type and client form of use. |
| 1 - Compatibility defaults | Allows Unicode columns to work in a way compatible with applications that were written to use Latin or Kanji1 columns. |
| 2 - Maximum defaults | Provides maximum default width of the character data type and client form of use. |
Default
0 (Expected defaults)
Changes Take Effect
After the next Teradata Database restart.
Usage Notes
The system-level export width can be overridden at the user level by use of EXPORTWIDTH option to the CREATE USER and MODIFY USER SQL statements. For more information, see SQL Data Definition Language.
Expected Default Export Widths
The following table illustrates the number of bytes exported from the various server character sets to the various client character sets for the Expected Default export width table (Export Width Table ID = 0).
| IF the client character set is… | AND the server character set is… | THEN the number of bytes exported for a CHARACTER(n) column is… |
|---|---|---|
| any single-byte character set |
|
n |
|
GRAPHIC is not supported.
|
||
| KANJIEUC_0U KANJISJIS_0S KANJI932_1S0 |
|
n |
|
2n | |
|
n | |
| KANJIEBCDIC5026_0I KANJIEBCDIC5035_0I KATAKANAEBCDIC |
|
n |
| UNICODE | 2n+2 | |
| GRAPHIC |
|
|
| UTF-8 | LATIN | 2n |
| UNICODE | 3n | |
|
n | |
|
GRAPHIC is not supported.
|
||
| UTF-16 |
|
2n |
|
|
n |
|
2n | |
|
|
n |
| UNICODE | 2n+2 | |
| GRAPHIC |
|
|
Compatibility Default Export Widths
The following table illustrates the number of bytes exported from the various server character sets to the various client character sets for the Compatibility Default export width table (Export Width Table ID = 1).
| IF the client character set is… | AND the server character set is… | THEN the number of bytes exported for a CHARACTER(n) column is… |
|---|---|---|
| any single-byte character set |
|
n |
|
GRAPHIC is not supported.
|
||
|
|
n |
| GRAPHIC | 2n | |
| KANJIEBCDIC5026_0I KANJIEBCDIC5035_0I KATAKANAEBCDIC |
|
n |
| GRAPHIC |
|
|
| UTF-8 | LATIN | 2n |
|
3n | |
|
n | |
|
GRAPHIC is not supported.
|
||
| UTF-16 |
|
2n |
|
|
n |
|
2n | |
|
|
n |
| GRAPHIC |
|
|
Maximum Default Export Widths
The following table illustrates the number of bytes exported from the various server character sets to the various client character sets for the Maximum Default export width table (Export Width Table ID = 2).
| IF the client character set is… | AND the server character set is… | THEN the number of bytes exported for a CHARACTER(n) column is… |
|---|---|---|
| any single-byte character set |
|
n |
|
GRAPHIC is not supported.
|
||
| KANJIEUC_0U |
|
3n |
|
n | |
| KANJIEBCDIC5026_0I KANJIEBCDIC5035_0I KATAKANAEBCDIC |
|
n |
| UNICODE | 3n+1 | |
| KANJISJIS | 2n | |
| GRAPHIC |
|
|
| KANJISJIS_0S KANJI932_1S0 |
|
2n |
|
n | |
| UTF-8 |
|
3n |
| KANJI1 | n | |
|
GRAPHIC is not supported.
|
||
| UTF-16 |
|
2n |
|
|
2n |
|
n | |
|
|
n |
| UNICODE | 3n+1 | |
| LATIN | 2n | |
| GRAPHIC |
|
|