15.00 - Export Width Table ID - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

Export Width Table ID

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

    Note: GRAPHIC is not supported.

    KANJIEUC_0U

    KANJISJIS_0S

    KANJI932_1S0

  • LATIN
  • KANJISJIS
  • KANJI1
  • n

  • UNICODE
  • GRAPHIC
  • 2n

    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

    Note: 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, first byte of double-byte characters 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

    Note: 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

    Note: 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, first byte of double-byte characters 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

    Note: 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

    Note: 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, first byte of double-byte characters 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)