15.10 - Client ASCII to Server UNICODE - 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 shows how Teradata Database maps Latin characters from the ASCII client character set to the UNICODE server character set. The translation works in both directions, from ASCII to UNICODE and from UNICODE to ASCII.

 

ASCII

UNICODE Latin

Unicode Character Name

0x00

U+0000

<control> NULL

0x01

U+0001

<control> START OF HEADING

0x02

U+0002

<control> START OF TEXT

0x03

U+0003

<control> END OF TEXT

0x04

U+0004

<control> END OF TRANSMISSION

0x05

U+0005

<control> ENQUIRY

0x06

U+0006

<control> ACKNOWLEDGE

0x07

U+0007

<control> BELL

0x08

U+0008

<control> BACKSPACE

0x09

U+0009

<control> CHARACTER TABULATION (horizontal tabulation)

0x0A

U+000A

<control> LINE FEED

0x0B

U+000B

<control> LINE TABULATION (vertical tabulation)

0x0C

U+000C

<control> FORM FEED

0x0D

U+000D

<control> CARRIAGE RETURN

0x0E

U+000E

<control> SHIFT OUT

0x0F

U+000F

<control> SHIFT IN

0x10

U+0010

<control> DATA LINK ESCAPE

0x11

U+0011

<control> DEVICE CONTROL ONE

0x12

U+0012

<control> DEVICE CONTROL TWO

0x13

U+0013

<control> DEVICE CONTROL THREE

0x14

U+0014

<control> DEVICE CONTROL FOUR

0x15

U+0015

<control> NEGATIVE ACKNOWLEDGE

0x16

U+0016

<control> SYNCHRONOUS IDLE

0x17

U+0017

<control> END OF TRANSMISSION BLOCK

0x18

U+0018

<control> CANCEL

0x19

U+0019

<control> END OF MEDIUM

0x1A

U+001A

<control> SUBSTITUTE

0x1B

U+001B

<control> ESCAPE

0x1C

U+001C

<control> INFORMATION SEPARATOR FOUR (file separator)

0x1D

U+001D

<control> INFORMATION SEPARATOR THREE (group separator)

0x1E

U+001E

<control> INFORMATION SEPARATOR TWO (record separator)

0x1F

U+001F

<control> INFORMATION SEPARATOR ONE (unit separator)

0x20

U+0020

SPACE

0x21

U+0021

EXCLAMATION MARK

0x22

U+0022

QUOTATION MARK

0x23

U+0023

NUMBER SIGN

0x24

U+0024

DOLLAR SIGN

0x25

U+0025

PERCENT SIGN

0x26

U+0026

AMPERSAND

0x27

U+0027

APOSTROPHE

0x28

U+0028

LEFT PARENTHESIS

0x29

U+0029

RIGHT PARENTHESIS

0x2A

U+002A

ASTERISK

0x2B

U+002B

PLUS SIGN

0x2C

U+002C

COMMA

0x2D

U+002D

HYPHEN-MINUS

0x2E

U+002E

FULL STOP

0x2F

U+002F

SOLIDUS

0x30

U+0030

DIGIT ZERO

0x31

U+0031

DIGIT ONE

0x32

U+0032

DIGIT TWO

0x33

U+0033

DIGIT THREE

0x34

U+0034

DIGIT FOUR

0x35

U+0035

DIGIT FIVE

0x36

U+0036

DIGIT SIX

0x37

U+0037

DIGIT SEVEN

0x38

U+0038

DIGIT EIGHT

0x39

U+0039

DIGIT NINE

0x3A

U+003A

COLON

0x3B

U+003B

SEMICOLON

0x3C

U+003C

LESS-THAN SIGN

0x3D

U+003D

EQUALS SIGN

0x3E

U+003E

GREATER-THAN SIGN

0x3F

U+003F

QUESTION MARK

0x40

U+0040

COMMERCIAL AT

0x41

U+0041

LATIN CAPITAL LETTER A

0x42

U+0042

LATIN CAPITAL LETTER B

0x43

U+0043

LATIN CAPITAL LETTER C

0x44

U+0044

LATIN CAPITAL LETTER D

0x45

U+0045

LATIN CAPITAL LETTER E

0x46

U+0046

LATIN CAPITAL LETTER F

0x47

U+0047

LATIN CAPITAL LETTER G

0x48

U+0048

LATIN CAPITAL LETTER H

0x49

U+0049

LATIN CAPITAL LETTER I

0x4A

U+004A

LATIN CAPITAL LETTER J

0x4B

U+004B

LATIN CAPITAL LETTER K

0x4C

U+004C

LATIN CAPITAL LETTER L

0x4D

U+004D

LATIN CAPITAL LETTER M

0x4E

U+004E

LATIN CAPITAL LETTER N

0x4F

U+004F

LATIN CAPITAL LETTER O

0x50

U+0050

LATIN CAPITAL LETTER P

0x51

U+0051

LATIN CAPITAL LETTER Q

0x52

U+0052

LATIN CAPITAL LETTER R

0x53

U+0053

LATIN CAPITAL LETTER S

0x54

U+0054

LATIN CAPITAL LETTER T

0x55

U+0055

LATIN CAPITAL LETTER U

0x56

U+0056

LATIN CAPITAL LETTER V

0x57

U+0057

LATIN CAPITAL LETTER W

0x58

U+0058

LATIN CAPITAL LETTER X

0x59

U+0059

LATIN CAPITAL LETTER Y

0x5A

U+005A

LATIN CAPITAL LETTER Z

0x5B

U+005B

LEFT SQUARE BRACKET

0x5C

U+005C

REVERSE SOLIDUS

0x5D

U+005D

RIGHT SQUARE BRACKET

0x5E

U+005E

CIRCUMFLEX ACCENT

0x5F

U+005F

LOW LINE

0x60

U+0060

GRAVE ACCENT

0x61

U+0061

LATIN SMALL LETTER A

0x62

U+0062

LATIN SMALL LETTER B

0x63

U+0063

LATIN SMALL LETTER C

0x64

U+0064

LATIN SMALL LETTER D

0x65

U+0065

LATIN SMALL LETTER E

0x66

U+0066

LATIN SMALL LETTER F

0x67

U+0067

LATIN SMALL LETTER G

0x68

U+0068

LATIN SMALL LETTER H

0x69

U+0069

LATIN SMALL LETTER I

0x6A

U+006A

LATIN SMALL LETTER J

0x6B

U+006B

LATIN SMALL LETTER K

0x6C

U+006C

LATIN SMALL LETTER L

0x6D

U+006D

LATIN SMALL LETTER M

0x6E

U+006E

LATIN SMALL LETTER N

0x6F

U+006F

LATIN SMALL LETTER O

0x70

U+0070

LATIN SMALL LETTER P

0x71

U+0071

LATIN SMALL LETTER Q

0x72

U+0072

LATIN SMALL LETTER R

0x73

U+0073

LATIN SMALL LETTER S

0x74

U+0074

LATIN SMALL LETTER T

0x75

U+0075

LATIN SMALL LETTER U

0x76

U+0076

LATIN SMALL LETTER V

0x77

U+0077

LATIN SMALL LETTER W

0x78

U+0078

LATIN SMALL LETTER X

0x79

U+0079

LATIN SMALL LETTER Y

0x7A

U+007A

LATIN SMALL LETTER Z

0x7B

U+007B

LEFT CURLY BRACKET

0x7C

U+007C

VERTICAL LINE

0x7D

U+007D

RIGHT CURLY BRACKET

0x7E

U+007E

TILDE

0x7F

U+007F

<control> DELETE

0x80

U+00A0

NO-BREAK SPACE

0x81

U+00A8

DIAERESIS

0x82

U+00B4

ACUTE ACCENT

0x83

U+00B8

CEDILLA

0x84

U+00D7

MULTIPLICATION SIGN

0x85

U+00F7

DIVISION SIGN

0x86

U+0086

<control> START OF SELECTED AREA

0x87

U+0087

<control> END OF SELECTED AREA

0x88

U+0088

<control> CHARACTER TABULATION SET

0x89

U+0089

<control> CHARACTER TABULATION WITH JUSTIFICATION

0x8A

U+008A

<control> LINE TABULATION SET

0x8B

U+008B

<control> PARTIAL LINE FORWARD

0x8C

U+008C

<control> PARTIAL LINE BACKWARD

0x8D

U+008D

<control> REVERSE LINE FEED

0x8E

U+008E

<control> SINGLE SHIFT TWO

0x8F

U+008F

<control> SINGLE SHIFT THREE

0x90

U+0090

<control> DEVICE CONTROL STRING

0x91

U+0091

<control> PRIVATE USE ONE

0x92

U+0092

<control> PRIVATE USE TWO

0x93

U+0093

<control> SET TRANSMIT STATE

0x94

U+0094

<control> CANCEL CHARACTER

0x95

U+0095

<control> MESSAGE WAITING

0x96

U+0096

<control> START OF GUARDED AREA

0x97

U+0097

<control> END OF GUARDED AREA

0x98

U+0098

<control> START OF STRING

0x99

U+0099

<control>

0x9A

U+009A

<control> SINGLE CHARACTER INTRODUCER

0x9B

U+009B

<control> CONTROL SEQUENCE INTRODUCER

0x9C

U+009C

<control> STRING TERMINATOR

0x9D

U+009D

<control> OPERATING SYSTEM COMMAND

0x9E

U+009E

<control> PRIVACY MESSAGE

0x9F

U+009F

<control> APPLICATION PROGRAM COMMAND

0xA0

U+0161

LATIN SMALL LETTER S WITH CARON

0xA1

U+00A1

INVERTED EXCLAMATION MARK

0xA2

U+00A2

CENT SIGN

0xA3

U+00A3

POUND SIGN

0xA4

U+00FD

LATIN SMALL LETTER Y WITH ACUTE

0xA5

U+00A5

YEN SIGN

0xA6

U+00A6

BROKEN BAR

0xA7

U+00A7

SECTION SIGN

0xA8

U+00A4

CURRENCY SIGN

0xA9

U+00A9

COPYRIGHT SIGN

0xAA

U+00AA

FEMININE ORDINAL INDICATOR

0xAB

U+00AB

LEFT-POINTING DOUBLE ANGLE QUOTATION MARK

0xAC

U+00AC

NOT SIGN

0xAD

U+00AD

SOFT HYPHEN

0xAE

U+00AE

REGISTERED SIGN

0xAF

U+00AF

MACRON

0xB0

U+00B0

DEGREE SIGN

0xB1

U+00B1

PLUS-MINUS SIGN

0xB2

U+00B2

SUPERSCRIPT TWO

0xB3

U+00B3

SUPERSCRIPT THREE

0xB4

U+00DD

LATIN CAPITAL LETTER Y WITH ACUTE

0xB5

U+00B5

MICRO SIGN

0xB6

U+00B6

PILCROW SIGN

0xB7

U+00B7

MIDDLE DOT

0xB8

U+0160

LATIN CAPITAL LETTER S WITH CARON

0xB9

U+00B9

SUPERSCRIPT ONE

0xBA

U+00BA

MASCULINE ORDINAL INDICATOR

0xBB

U+00BB

RIGHT-POINTING DOUBLE ANGLE QUOTATION MARK

0xBC

U+00BC

VULGAR FRACTION ONE QUARTER

0xBD

U+00BD

VULGAR FRACTION ONE HALF

0xBE

U+00BE

VULGAR FRACTION THREE QUARTERS

0xBF

U+00BF

INVERTED QUESTION MARK

0xC0

U+00C0

LATIN CAPITAL LETTER A WITH GRAVE

0xC1

U+00C1

LATIN CAPITAL LETTER A WITH ACUTE

0xC2

U+00C2

LATIN CAPITAL LETTER A WITH CIRCUMFLEX

0xC3

U+00C3

LATIN CAPITAL LETTER A WITH TILDE

0xC4

U+00C4

LATIN CAPITAL LETTER A WITH DIAERESIS

0xC5

U+00C5

LATIN CAPITAL LETTER A WITH RING ABOVE

0xC6

U+00C6

LATIN CAPITAL LETTER AE

0xC7

U+00C7

LATIN CAPITAL LETTER C WITH CEDILLA

0xC8

U+00C8

LATIN CAPITAL LETTER E WITH GRAVE

0xC9

U+00C9

LATIN CAPITAL LETTER E WITH ACUTE

0xCA

U+00CA

LATIN CAPITAL LETTER E WITH CIRCUMFLEX

0xCB

U+00CB

LATIN CAPITAL LETTER E WITH DIAERESIS

0xCC

U+00CC

LATIN CAPITAL LETTER I WITH GRAVE

0xCD

U+00CD

LATIN CAPITAL LETTER I WITH ACUTE

0xCE

U+00CE

LATIN CAPITAL LETTER I WITH CIRCUMFLEX

0xCF

U+00CF

LATIN CAPITAL LETTER I WITH DIAERESIS

0xD0

U+00F0

LATIN SMALL LETTER ETH

0xD1

U+00D1

LATIN CAPITAL LETTER N WITH TILDE

0xD2

U+00D2

LATIN CAPITAL LETTER O WITH GRAVE

0xD3

U+00D3

LATIN CAPITAL LETTER O WITH ACUTE

0xD4

U+00D4

LATIN CAPITAL LETTER O WITH CIRCUMFLEX

0xD5

U+00D5

LATIN CAPITAL LETTER O WITH TILDE

0xD6

U+00D6

LATIN CAPITAL LETTER O WITH DIAERESIS

0xD7

U+0152

LATIN CAPITAL LIGATURE OE

0xD8

U+00D8

LATIN CAPITAL LETTER O WITH STROKE

0xD9

U+00D9

LATIN CAPITAL LETTER U WITH GRAVE

0xDA

U+00DA

LATIN CAPITAL LETTER U WITH ACUTE

0xDB

U+00DB

LATIN CAPITAL LETTER U WITH CIRCUMFLEX

0xDC

U+00DC

LATIN CAPITAL LETTER U WITH DIAERESIS

0xDD

U+0178

LATIN CAPITAL LETTER Y WITH DIAERESIS

0xDE

U+00FE

LATIN SMALL LETTER THORN

0xDF

U+00DF

LATIN SMALL LETTER SHARP S

0xE0

U+00E0

LATIN SMALL LETTER A WITH GRAVE

0xE1

U+00E1

LATIN SMALL LETTER A WITH ACUTE

0xE2

U+00E2

LATIN SMALL LETTER A WITH CIRCUMFLEX

0xE3

U+00E3

LATIN SMALL LETTER A WITH TILDE

0xE4

U+00E4

LATIN SMALL LETTER A WITH DIAERESIS

0xE5

U+00E5

LATIN SMALL LETTER A WITH RING ABOVE

0xE6

U+00E6

LATIN SMALL LETTER AE

0xE7

U+00E7

LATIN SMALL LETTER C WITH CEDILLA

0xE8

U+00E8

LATIN SMALL LETTER E WITH GRAVE

0xE9

U+00E9

LATIN SMALL LETTER E WITH ACUTE

0xEA

U+00EA

LATIN SMALL LETTER E WITH CIRCUMFLEX

0xEB

U+00EB

LATIN SMALL LETTER E WITH DIAERESIS

0xEC

U+00EC

LATIN SMALL LETTER I WITH GRAVE

0xED

U+00ED

LATIN SMALL LETTER I WITH ACUTE

0xEE

U+00EE

LATIN SMALL LETTER I WITH CIRCUMFLEX

0xEF

U+00EF

LATIN SMALL LETTER I WITH DIAERESIS

0xF0

U+00D0

LATIN CAPITAL LETTER ETH

0xF1

U+00F1

LATIN SMALL LETTER N WITH TILDE

0xF2

U+00F2

LATIN SMALL LETTER O WITH GRAVE

0xF3

U+00F3

LATIN SMALL LETTER O WITH ACUTE

0xF4

U+00F4

LATIN SMALL LETTER O WITH CIRCUMFLEX

0xF5

U+00F5

LATIN SMALL LETTER O WITH TILDE

0xF6

U+00F6

LATIN SMALL LETTER O WITH DIAERESIS

0xF7

U+0153

LATIN SMALL LIGATURE OE

0xF8

U+00F8

LATIN SMALL LETTER O WITH STROKE

0xF9

U+00F9

LATIN SMALL LETTER U WITH GRAVE

0xFA

U+00FA

LATIN SMALL LETTER U WITH ACUTE

0xFB

U+00FB

LATIN SMALL LETTER U WITH CIRCUMFLEX

0xFC

U+00FC

LATIN SMALL LETTER U WITH DIAERESIS

0xFD

U+00FF

LATIN SMALL LETTER Y WITH DIAERESIS

0xFE

U+00DE

LATIN CAPITAL LETTER THORN

0xFF

U+20AC

EURO SIGN