Export Width Table ID - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

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 Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

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)