15.10 - Non-GRAPHIC Characters - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Configuration
User Guide
featnum
B035-1125-015K

The following table identifies non-GRAPHIC characters in the UNICODE server character set.

Teradata Database substitutes the GRAPHIC REPLACEMENT CHARACTER (0xFFFD) for non-GRAPHIC characters when you use the TRANSLATE function and specify the following:

  • WITH ERROR option
  • UNICODE_TO_GRAPHIC
  •  

    Code

    Unicode Character Name

    Code

    Unicode Character Name

    U+0000

    <control> NULL

    U+0092

    <control> PRIVATE USE TWO

    U+0001

    <control> START OF HEADING

    U+0093

    <control> SET TRANSMIT RATE

    U+0002

    <control> START OF TEXT

    U+0094

    <control> CANCEL CHARACTER

    U+0003

    <control> END OF TEXT

    U+0095

    <control> MESSAGE WAITING

    U+0004

    <control> END OF TRANSMISSION

    U+0096

    <control> START OF GUARDED AREA

    U+0005

    <control> ENQUIRY

    U+0097

    <control> END OF GUARDED AREA

    U+0006

    <control> ACKNOWLEDGE

    U+0098

    <control> START OF STRING

    U+0007

    <control> BELL

    U+0099

    <control>

    U+0008

    <control> BACKSPACE

    U+009A

    <control> SINGLE CHARACTER INTRODUCER

    U+0009

    <control> CHARACTER TABULATION (horizontal tabulation)

    U+009B

    <control> CONTROL SEQUENCE INTRODUCER

    U+000A

    <control> LINE FEED

    U+009C

    <control> STRING TERMINATOR

    U+000B

    <control> LINE TABULATION (vertical tabulation)

    U+009D

    <control> OPERATING SYSTEM COMMAND

    U+000C

    <control> FORM FEED

    U+009E

    <control> PRIVACY MESSAGE

    U+000D

    <control> CARRIAGE RETURN

    U+009F

    <control> APPLICATION PROGRAM COMMAND

    U+000E

    <control> SHIFT OUT

    U+00A2

    CENT SIGN

    U+000F

    <control> SHIFT IN

    U+00A3

    POUND SIGN

    U+0010

    <control> DATA LINK ESCAPE

    U+00A5

    YEN SIGN

    U+0011

    <control> DEVICE CONTROL ONE

    U+00A6

    BROKEN BAR

    U+0012

    <control> DEVICE CONTRO TWO

    U+00AC

    NOT SIGN

    U+0013

    <control> DEVICE CONTROL THREE

    U+00AF

    MACRON

    U+0014

    <control> DEVICE CONTROL FOUR

    U+203E

    OVERLINE

    U+0015

    <control> NEGATIVE ACKNOWLEDGE

    U+20A9

    WON SIGN

    U+0016

    <control> SYNCHRONOUS IDLE

    0x2985

    LEFT WHITE PARENTHESIS

    U+0017

    <control> END OF TRANSMISSION BLOCK

    0x2986

    RIGHT WHITE PARENTHESIS

    U+0018

    <control> CANCEL

    U+FF61

    HALFWIDTH IDEOGRAPHIC FULL STOP

    U+0019

    <control> END OF MEDIUM

    U+FF62

    HALFWIDTH LEFT CORNER BRACKET

    U+001A

    <control> SUBSTITUTE

    U+FF63

    HALFWIDTH RIGHT CORNER BRACKET

    U+001B

    <control> ESCAPE

    U+FF64

    HALFWIDTH IDEOGRAPHIC COMMA

    U+001C

    <control> INFORMATION SEPARATOR FOUR (file separator)

    U+FF65

    HALFWIDTH KATAKANA MIDDLE DOT

    U+001D

    <control> INFORMATION SEPARATOR THREE (group separator)

    U+FF66

    HALFWIDTH KATAKANA LETTER WO

    U+001E

    <control> INFORMATION SEPARATOR TWO (record separator)

    U+FF67

    HALFWIDTH KATAKANA LETTER SMALL A

    U+001F

    <control> INFORMATION SEPARATOR ONE (unit separator)

    U+FF68

    HALFWIDTH KATAKANA LETTER SMALL I

    U+0020

    SPACE

    U+FF69

    HALFWIDTH KATAKANA LETTER SMALL U

    U+0021

    EXCLAMATION MARK

    U+FF6A

    HALFWIDTH KATAKANA LETTER SMALL E

    U+0022

    QUOTATION MARK

    U+FF6B

    HALFWIDTH KATAKANA LETTER SMALL O

    U+0023

    NUMBER SIGN

    U+FF6C

    HALFWIDTH KATAKANA LETTER SMALL YA

    U+0024

    DOLLAR SIGN

    U+FF6D

    HALFWIDTH KATAKANA LETTER SMALL YU

    U+0025

    PERCENT SIGN

    U+FF6E

    HALFWIDTH KATAKANA LETTER SMALL YO

    U+0026

    AMPERSAND

    U+FF6F

    HALFWIDTH KATAKANA LETTER SMALL TU

    U+0027

    APOSTROPHE

    U+FF70

    HALFWIDTH KATAKANA-HIRAGANA PROLONGED SOUND MARK

    U+0028

    LEFT PARENTHESIS

    U+FF71

    HALFWIDTH KATAKANA LETTER A

    U+0029

    RIGHT PARENTHESIS

    U+FF72

    HALFWIDTH KATAKANA LETTER I

    U+002A

    ASTERISK

    U+FF73

    HALFWIDTH KATAKANA LETTER U

    U+002B

    PLUS SIGN

    U+FF74

    HALFWIDTH KATAKANA LETTER E

    U+002C

    COMMA

    U+FF75

    HALFWIDTH KATAKANA LETTER O

    U+002D

    HYPHEN-MINUS

    U+FF76

    HALFWIDTH KATAKANA LETTER KA

    U+002E

    FULL STOP

    U+FF77

    HALFWIDTH KATAKANA LETTER KI

    U+002F

    SOLIDUS

    U+FF78

    HALFWIDTH KATAKANA LETTER KU

    U+0030

    DIGIT ZERO

    U+FF79

    HALFWIDTH KATAKANA LETTER KE

    U+0031

    DIGIT ONE

    U+FF7A

    HALFWIDTH KATAKANA LETTER KO

    U+0032

    DIGIT TWO

    U+FF7B

    HALFWIDTH KATAKANA LETTER SA

    U+0033

    DIGIT THREE

    U+FF7C

    HALFWIDTH KATAKANA LETTER SI

    U+0034

    DIGIT FOUR

    U+FF7D

    HALFWIDTH KATAKANA LETTER SU

    U+0035

    DIGIT FIVE

    U+FF7E

    HALFWIDTH KATAKANA LETTER SE

    U+0036

    DIGIT SIX

    U+FF7F

    HALFWIDTH KATAKANA LETTER SO

    U+0037

    DIGIT SEVEN

    U+FF80

    HALFWIDTH KATAKANA LETTER TA

    U+0038

    DIGIT EIGHT

    U+FF81

    HALFWIDTH KATAKANA LETTER TI

    U+0039

    DIGIT NINE

    U+FF82

    HALFWIDTH KATAKANA LETTER TU

    U+003A

    COLON

    U+FF83

    HALFWIDTH KATAKANA LETTER TE

    U+003B

    SEMICOLON

    U+FF84

    HALFWIDTH KATAKANA LETTER TO

    U+003C

    LESS-THAN SIGN

    U+FF85

    HALFWIDTH KATAKANA LETTER NA

    U+003D

    EQUALS SIGN

    U+FF86

    HALFWIDTH KATAKANA LETTER NI

    U+003E

    GREATER-THAN SIGN

    U+FF87

    HALFWIDTH KATAKANA LETTER NU

    U+003F

    QUESTION MARK

    U+FF88

    HALFWIDTH KATAKANA LETTER NE

    U+0040

    COMMERCIAL AT

    U+FF89

    HALFWIDTH KATAKANA LETTER NO

    U+0041

    LATIN CAPITAL LETTER A

    U+FF8A

    HALFWIDTH KATAKANA LETTER HA

    U+0042

    LATIN CAPITAL LETTER B

    U+FF8B

    HALFWIDTH KATAKANA LETTER HI

    U+0043

    LATIN CAPITAL LETTER C

    U+FF8C

    HALFWIDTH KATAKANA LETTER HU

    U+0044

    LATIN CAPITAL LETTER D

    U+FF8D

    HALFWIDTH KATAKANA LETTER HE

    U+0045

    LATIN CAPITAL LETTER E

    U+FF8E

    HALFWIDTH KATAKANA LETTER HO

    U+0046

    LATIN CAPITAL LETTER F

    U+FF8F

    HALFWIDTH KATAKANA LETTER MA

    U+0047

    LATIN CAPITAL LETTER G

    U+FF90

    HALFWIDTH KATAKANA LETTER MI

    U+0048

    LATIN CAPITAL LETTER H

    U+FF91

    HALFWIDTH KATAKANA LETTER MU

    U+0049

    LATIN CAPITAL LETTER I

    U+FF92

    HALFWIDTH KATAKANA LETTER ME

    U+004A

    LATIN CAPITAL LETTER J

    U+FF93

    HALFWIDTH KATAKANA LETTER MO

    U+004B

    LATIN CAPITAL LETTER K

    U+FF94

    HALFWIDTH KATAKANA LETTER YA

    U+004C

    LATIN CAPITAL LETTER L

    U+FF95

    HALFWIDTH KATAKANA LETTER YU

    U+004D

    LATIN CAPITAL LETTER M

    U+FF96

    HALFWIDTH KATAKANA LETTER YO

    U+004E

    LATIN CAPITAL LETTER N

    U+FF97

    HALFWIDTH KATAKANA LETTER RA

    U+004F

    LATIN CAPITAL LETTER O

    U+FF98

    HALFWIDTH KATAKANA LETTER RI

    U+0050

    LATIN CAPITAL LETTER P

    U+FF99

    HALFWIDTH KATAKANA LETTER RU

    U+0051

    LATIN CAPITAL LETTER Q

    U+FF9A

    HALFWIDTH KATAKANA LETTER RE

    U+0052

    LATIN CAPITAL LETTER R

    U+FF9B

    HALFWIDTH KATAKANA LETTER RO

    U+0053

    LATIN CAPITAL LETTER S

    U+FF9C

    HALFWIDTH KATAKANA LETTER WA

    U+0054

    LATIN CAPITAL LETTER T

    U+FF9D

    HALFWIDTH KATAKANA LETTER N

    U+0055

    LATIN CAPITAL LETTER U

    U+FF9E

    HALFWIDTH KATAKANA VOICED SOUND MARK

    U+0056

    LATIN CAPITAL LETTER V

    U+FF9F

    HALFWIDTH KATAKANA SEMI-VOICED SOUND MARK

    U+0057

    LATIN CAPITAL LETTER W

    U+FFA0

    HALFWIDTH HANGUL FILLER

    U+0058

    LATIN CAPITAL LETTER X

    U+FFA1

    HALFWIDTH HANGUL LETTER KIYEOK

    U+0059

    LATIN CAPITAL LETTER Y

    U+FFA2

    HALFWIDTH HANGUL LETTER SSANGKIYEOK

    U+005A

    LATIN CAPITAL LETTER Z

    U+FFA3

    HALFWIDTH HANGUL LETTER KIYEOK-SIOS

    U+005B

    LEFT SQUARE BRACKET

    U+FFA4

    HALFWIDTH HANGUL LETTER NIEUN

    U+005C

    REVERSE SOLIDUS

    U+FFA5

    HALFWIDTH HANGUL LETTER NIEUN-CIEUC

    U+005D

    RIGHT SQUARE BRACKET

    U+FFA6

    HALFWIDTH HANGUL LETTER NIEUN-HIEUH

    U+005E

    CIRCUMFLEX ACCENT

    U+FFA7

    HALFWIDTH HANGUL LETTER TIKEUT

    U+005F

    LOW LINE

    U+FFA8

    HALFWIDTH HANGUL LETTER SSANGTIKEUT

    U+0060

    GRAVE ACCENT

    U+FFA9

    HALFWIDTH HANGUL LETTER RIEUL

    U+0061

    LATIN SMALL LETTER A

    U+FFAA

    HALFWIDTH HANGUL LETTER RIEUL-KIYEOK

    U+0062

    LATIN SMALL LETTER B

    U+FFAB

    HALFWIDTH HANGUL LETTER RIEUL-MIEUM

    U+0063

    LATIN SMALL LETTER C

    U+FFAC

    HALFWIDTH HANGUL LETTER RIEUL-PIEUP

    U+0064

    LATIN SMALL LETTER D

    U+FFAD

    HALFWIDTH HANGUL LETTER RIEUL-SIOS

    U+0065

    LATIN SMALL LETTER E

    U+FFAE

    HALFWIDTH HANGUL LETTER RIEUL-THIEUTH

    U+0066

    LATIN SMALL LETTER F

    U+FFAF

    HALFWIDTH HANGUL LETTER RIEUL-PHIEUPH

    U+0067

    LATIN SMALL LETTER G

    U+FFB0

    HALFWIDTH HANGUL LETTER RIEUL-HIEUH

    U+0068

    LATIN SMALL LETTER H

    U+FFB1

    HALFWIDTH HANGUL LETTER MIEUM

    U+0069

    LATIN SMALL LETTER I

    U+FFB2

    HALFWIDTH HANGUL LETTER PIEUP

    U+006A

    LATIN SMALL LETTER J

    U+FFB3

    HALFWIDTH HANGUL LETTER SSANGPIEUP

    U+006B

    LATIN SMALL LETTER K

    U+FFB4

    HALFWIDTH HANGUL LETTER PIEUP-SIOS

    U+006C

    LATIN SMALL LETTER L

    U+FFB5

    HALFWIDTH HANGUL LETTER SIOS

    U+006D

    LATIN SMALL LETTER M

    U+FFB6

    HALFWIDTH HANGUL LETTER SSANGSIOS

    U+006E

    LATIN SMALL LETTER N

    U+FFB7

    HALFWIDTH HANGUL LETTER IEUNG

    U+006F

    LATIN SMALL LETTER O

    U+FFB8

    HALFWIDTH HANGUL LETTER CIEUC

    U+0070

    LATIN SMALL LETTER P

    U+FFB9

    HALFWIDTH HANGUL LETTER SSANGCIEUC

    U+0071

    LATIN SMALL LETTER Q

    U+FFBA

    HALFWIDTH HANGUL LETTER CHIEUCH

    U+0072

    LATIN SMALL LETTER R

    U+FFBB

    HALFWIDTH HANGUL LETTER KHIEUKH

    U+0073

    LATIN SMALL LETTER S

    U+FFBC

    HALFWIDTH HANGUL LETTER THIEUTH

    U+0074

    LATIN SMALL LETTER T

    U+FFBD

    HALFWIDTH HANGUL LETTER PHIEUPH

    U+0075

    LATIN SMALL LETTER U

    U+FFBE

    HALFWIDTH HANGUL LETTER HIEUH

    U+0076

    LATIN SMALL LETTER V

    U+FFC2

    HALFWIDTH HANGUL LETTER A

    U+0077

    LATIN SMALL LETTER W

    U+FFC3

    HALFWIDTH HANGUL LETTER AE

    U+0078

    LATIN SMALL LETTER X

    U+FFC4

    HALFWIDTH HANGUL LETTER YA

    U+0079

    LATIN SMALL LETTER Y

    U+FFC5

    HALFWIDTH HANGUL LETTER YAE

    U+007A

    LATIN SMALL LETTER Z

    U+FFC6

    HALFWIDTH HANGUL LETTER EO

    U+007B

    LEFT CURLY BRACKET

    U+FFC7

    HALFWIDTH HANGUL LETTER E

    U+007C

    VERTICAL LINE

    U+FFCA

    HALFWIDTH HANGUL LETTER YEO

    U+007D

    RIGHT CURLY BRACKET

    U+FFCB

    HALFWIDTH HANGUL LETTER YE

    U+007E

    TILDE

    U+FFCC

    HALFWIDTH HANGUL LETTER O

    U+007F

    <control> DELETE

    U+FFCD

    HALFWIDTH HANGUL LETTER WA

    U+0080

    <control>

    U+FFCE

    HALFWIDTH HANGUL LETTER WAE

    U+0081

    <control>

    U+FFCF

    HALFWIDTH HANGUL LETTER OE

    U+0082

    <control> BREAK PERMITTED HERE

    U+FFD2

    HALFWIDTH HANGUL LETTER YO

    U+0083

    <control> NO BREAK HERE

    U+FFD3

    HALFWIDTH HANGUL LETTER U

    U+0084

    <control>

    U+FFD4

    HALFWIDTH HANGUL LETTER WEO

    U+0085

    <control> NEXT LINE (NEL)

    U+FFD5

    HALFWIDTH HANGUL LETTER WE

    U+0086

    <control> START OF SELECTED AREA

    U+FFD6

    HALFWIDTH HANGUL LETTER WI

    U+0087

    <control> END OF SELECTED AREA

    U+FFD7

    HALFWIDTH HANGUL LETTER YU

    U+0088

    <control> CHARACTER TABULATION SET

    U+FFDA

    HALFWIDTH HANGUL LETTER EU

    U+0089

    <control> CHARACTER TABULATION WITH JUSTIFICATION

    U+FFDB

    HALFWIDTH HANGUL LETTER YI

    U+008A

    <control> LINE TABULATION SET

    U+FFDC

    HALFWIDTH HANGUL LETTER I

    U+008B

    <control> PARTIAL LINE FORWARD

    U+FFE8

    HALFWIDTH FORMS LIGHT VERTICAL

    U+008C

    <control> PARTIAL LINE BACKWARD

    U+FFE9

    HALFWIDTH LEFTWARDS ARROW

    U+008D

    <control> REVERSE LINE FEED

    U+FFEA

    HALFWIDTH UPWARDS ARROW

    U+008E

    <control> SINGLE SHIFT TWO

    U+FFEB

    HALFWIDTH RIGHTWARDS ARROW

    U+008F

    <control> SINGLE SHIFT THREE

    U+FFEC

    HALFWIDTH DOWNWARDS ARROW

    U+0090

    <control> DEVICE CONTROL STRING

    U+FFED

    HALFWIDTH BLACK SQUARE

    U+0091

    <control> PRIVATE USE ONE

    U+FFEE

    HALFWIDTH WHITE CIRCLE