16.10 - Export Width Table ID - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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
  • LATIN
  • UNICODE
  • KANJISJIS
  • KANJI1
n
GRAPHIC is not supported.
KANJIEUC_0U

KANJISJIS_0S

KANJI932_1S0

  • LATIN
  • KANJISJIS
  • KANJI1
n
  • UNICODE
  • GRAPHIC
2n
  • UNICODE
  • GRAPHIC
n
KANJIEBCDIC5026_0I

KANJIEBCDIC5035_0I

KATAKANAEBCDIC

  • LATIN
  • KANJISJIS
  • KANJI1
n
UNICODE 2n+2
GRAPHIC
  • 2n (record and indicator modes)
  • 2n+2 (field mode)
UTF-8 LATIN 2n
UNICODE 3n
  • KANJISJIS
  • KANJI1
n
GRAPHIC is not supported.
UTF-16
  • LATIN
  • UNICODE
  • KANJISJIS
  • KANJI1
  • GRAPHIC
2n
  • HANGUL949_7R0
  • HANGULKSC5601_2R4
  • SCHGB2312_1T0
  • SCHINESE936_6R0
  • SDHANGULKSC5601_4R4
  • SDTCHBIG5_3R0
  • SDSCHGB2312_2T0
  • TCHBIG5_1R0
  • TCHINESE950_8R0
  • Extended site-defined multibyte client character sets that use one of the following encoding forms:
    • Single-byte characters in the range 0x00-0x81
    • double-byte characters with first byte in the range 0x82-0xFF
  • LATIN
  • KANJISJIS
  • KANJI1
n
  • UNICODE
  • GRAPHIC
2n
  • HANGULEBCDIC933_1II
  • SCHEBCDIC935_21J
  • SDHANGULEBCDIC933_5II
  • SDSCHEBCDIC935_6IJ
  • SDTCHEBCDIC937_7IB
  • TCHEBCDIC937_3IB
  • LATIN
  • KANJISJIS
  • KANJI1
n
UNICODE 2n+2
GRAPHIC
  • 2n (record and indicator modes)
  • 2n+2 (field mode)

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
  • LATIN
  • UNICODE
  • KANJISJIS
  • KANJI1
n
GRAPHIC is not supported.
  • KANJIEUC_0U
  • KANJISJIS_0S
  • KANJI932_1S0
  • LATIN
  • UNICODE
  • KANJISJIS
  • KANJI1
n
GRAPHIC 2n
KANJIEBCDIC5026_0I

KANJIEBCDIC5035_0I

KATAKANAEBCDIC

  • LATIN
  • UNICODE
  • KANJISJIS
  • KANJI1
n
GRAPHIC
  • 2n (record and indicator modes)
  • 2n+2 (field mode)
UTF-8 LATIN 2n
  • UNICODE
3n
  • KANJISJIS
  • KANJI1
n
GRAPHIC is not supported.
UTF-16
  • LATIN
  • UNICODE
  • KANJISJIS
  • KANJI1
  • GRAPHIC
2n
  • HANGUL949_7R0
  • HANGULKSC5601_2R4
  • SCHGB2312_1T0
  • SCHINESE936_6R0
  • SDHANGULKSC5601_4R4
  • SDTCHBIG5_3R0
  • SDSCHGB2312_2T0
  • TCHBIG5_1R0
  • TCHINESE950_8R0
  • Extended site-defined multibyte client character sets that use one of the following encoding forms:
    • Single-byte characters in the range 0x00-0x81
    • double-byte characters with first byte in the range 0x82-0xFF
  • LATIN
  • UNICODE
  • KANJISJIS
  • KANJI1
n
 
  • GRAPHIC
2n
  • HANGULEBCDIC933_1II
  • SCHEBCDIC935_21J
  • SDHANGULEBCDIC933_5II
  • SDSCHEBCDIC935_6IJ
  • SDTCHEBCDIC937_7IB
  • TCHEBCDIC937_3IB
  • LATIN
  • UNICODE
  • KANJISJIS
  • KANJI1
n
GRAPHIC
  • 2n (record and indicator modes)
  • 2n+2 (field mode)

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
  • LATIN
  • UNICODE
  • KANJISJIS
  • KANJI1
n
GRAPHIC is not supported.
KANJIEUC_0U
  • LATIN
  • UNICODE
  • GRAPHIC
3n
  • KANJISJIS
  • KANJI1
n
KANJIEBCDIC5026_0I

KANJIEBCDIC5035_0I

KATAKANAEBCDIC

  • LATIN
  • KANJI1
n
UNICODE 3n+1
KANJISJIS 2n
GRAPHIC
  • 2n (record and indicator modes)
  • 2n+2 (field mode)
KANJISJIS_0S

KANJI932_1S0

  • LATIN
  • UNICODE
  • GRAPHIC
2n
  • KANJISJIS
  • KANJI1
n
UTF-8
  • LATIN
  • UNICODE
  • KANJISJIS
3n
KANJI1 n
GRAPHIC is not supported.
UTF-16
  • LATIN
  • UNICODE
  • KANJISJIS
  • KANJI1
  • GRAPHIC
2n
  • HANGUL949_7R0
  • HANGULKSC5601_2R4
  • SCHGB2312_1T0
  • SCHINESE936_6R0
  • SDHANGULKSC5601_4R4
  • SDTCHBIG5_3R0
  • SDSCHGB2312_2T0
  • TCHBIG5_1R0
  • TCHINESE950_8R0
  • Extended site-defined multibyte client character sets that use one of the following encoding forms:
    • Single-byte characters in the range 0x00-0x81
    • double-byte characters with first byte in the range 0x82-0xFF
  • LATIN
  • UNICODE
  • GRAPHIC
2n
  • KANJISJIS
  • KANJI1
n
  • HANGULEBCDIC933_1II
  • SCHEBCDIC935_21J
  • SDHANGULEBCDIC933_5II
  • SDSCHEBCDIC935_6IJ
  • SDTCHEBCDIC937_7IB
  • TCHEBCDIC937_3IB
  • KANJISJIS
  • KANJI1
n
UNICODE 3n+1
LATIN 2n
GRAPHIC
  • 2n (record and indicator modes)
  • 2n+2 (field mode)