15.10 - UNICODE to LATIN - 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

This section maps UNICODE characters to their LATIN equivalents. Teradata Database uses this mapping when you translate a UNICODE string using the TRANSLATE function and specify UNICODE_TO_LATIN.

 

UNICODE

LATIN

Unicode Character Name

U+0000

0x00

<control> NULL

U+0001

0x01

<control> START OF HEADING

U+0002

0x02

<control> START OF TEXT

U+0003

0x03

<control> END OF TEXT

U+0004

0x04

<control> END OF TRANSMISSION

U+0005

0x05

<control> ENQUIRY

U+0006

0x06

<control> ACKNOWLEDGE

U+0007

0x07

<control> BELL

U+0008

0x08

<control> BACKSPACE

U+0009

0x09

<control> CHARACTER TABULATION (horizontal tabulation)

U+000A

0x0A

<control> LINE FEED

U+000B

0x0B

<control> LINE TABULATION (vertical tabulation)

U+000C

0x0C

<control> FORM FEED

U+000D

0x0D

<control> CARRIAGE RETURN

U+000E

0x0E

<control> SHIFT OUT

U+000F

0x0F

<control> SHIFT IN

U+0010

0x10

<control> DATA LINK ESCAPE

U+0011

0x11

<control> DEVICE CONTROL ONE

U+0012

0x12

<control> DEVICE CONTRO TWO

U+0013

0x13

<control> DEVICE CONTROL THREE

U+0014

0x14

<control> DEVICE CONTROL FOUR

U+0015

0x15

<control> NEGATIVE ACKNOWLEDGE

U+0016

0x16

<control> SYNCHRONOUS IDLE

U+0017

0x17

<control> END OF TRANSMISSION BLOCK

U+0018

0x18

<control> CANCEL

U+0019

0x19

<control> END OF MEDIUM

U+001A

0x1A

<control> SUBSTITUTE

U+001B

0x1B

<control> ESCAPE

U+001C

0x1C

<control> INFORMATION SEPARATOR FOUR (file separator)

U+001D

0x1D

<control> INFORMATION SEPARATOR THREE (group separator)

U+001E

0x1E

<control> INFORMATION SEPARATOR TWO (record separator)

U+001F

0x1F

<control> INFORMATION SEPARATOR ONE (unit separator)

U+0020

0x20

SPACE

U+0021

0x21

EXCLAMATION MARK

U+0022

0x22

QUOTATION MARK

U+0023

0x23

NUMBER SIGN

U+0024

0x24

DOLLAR SIGN

U+0025

0x25

PERCENT SIGN

U+0026

0x26

AMPERSAND

U+0027

0x27

APOSTROPHE

U+0028

0x28

LEFT PARENTHESIS

U+0029

0x29

RIGHT PARENTHESIS

U+002A

0x2A

ASTERISK

U+002B

0x2B

PLUS SIGN

U+002C

0x2C

COMMA

U+002D

0x2D

HYPHEN-MINUS

U+002E

0x2E

FULL STOP

U+002F

0x2F

SOLIDUS

U+0030

0x30

DIGIT ZERO

U+0031

0x31

DIGIT ONE

U+0032

0x32

DIGIT TWO

U+0033

0x33

DIGIT THREE

U+0034

0x34

DIGIT FOUR

U+0035

0x35

DIGIT FIVE

U+0036

0x36

DIGIT SIX

U+0037

0x37

DIGIT SEVEN

U+0038

0x38

DIGIT EIGHT

U+0039

0x39

DIGIT NINE

U+003A

0x3A

COLON

U+003B

0x3B

SEMICOLON

U+003C

0x3C

LESS-THAN SIGN

U+003D

0x3D

EQUALS SIGN

U+003E

0x3E

GREATER-THAN SIGN

U+003F

0x3F

QUESTION MARK

U+0040

0x40

COMMERCIAL AT

U+0041

0x41

LATIN CAPITAL LETTER A

U+0042

0x42

LATIN CAPITAL LETTER B

U+0043

0x43

LATIN CAPITAL LETTER C

U+0044

0x44

LATIN CAPITAL LETTER D

U+0045

0x45

LATIN CAPITAL LETTER E

U+0046

0x46

LATIN CAPITAL LETTER F

U+0047

0x47

LATIN CAPITAL LETTER G

U+0048

0x48

LATIN CAPITAL LETTER H

U+0049

0x49

LATIN CAPITAL LETTER I

U+004A

0x4A

LATIN CAPITAL LETTER J

U+004B

0x4B

LATIN CAPITAL LETTER K

U+004C

0x4C

LATIN CAPITAL LETTER L

U+004D

0x4D

LATIN CAPITAL LETTER M

U+004E

0x4E

LATIN CAPITAL LETTER N

U+004F

0x4F

LATIN CAPITAL LETTER O

U+0050

0x50

LATIN CAPITAL LETTER P

U+0051

0x51

LATIN CAPITAL LETTER Q

U+0052

0x52

LATIN CAPITAL LETTER R

U+0053

0x53

LATIN CAPITAL LETTER S

U+0054

0x54

LATIN CAPITAL LETTER T

U+0055

0x55

LATIN CAPITAL LETTER U

U+0056

0x56

LATIN CAPITAL LETTER V

U+0057

0x57

LATIN CAPITAL LETTER W

U+0058

0x58

LATIN CAPITAL LETTER X

U+0059

0x59

LATIN CAPITAL LETTER Y

U+005A

0x5A

LATIN CAPITAL LETTER Z

U+005B

0x5B

LEFT SQUARE BRACKET

U+005C

0x5C

REVERSE SOLIDUS

U+005D

0x5D

RIGHT SQUARE BRACKET

U+005E

0x5E

CIRCUMFLEX ACCENT

U+005F

0x5F

LOW LINE

U+0060

0x60

GRAVE ACCENT

U+0061

0x61

LATIN SMALL LETTER A

U+0062

0x62

LATIN SMALL LETTER B

U+0063

0x63

LATIN SMALL LETTER C

U+0064

0x64

LATIN SMALL LETTER D

U+0065

0x65

LATIN SMALL LETTER E

U+0066

0x66

LATIN SMALL LETTER F

U+0067

0x67

LATIN SMALL LETTER G

U+0068

0x68

LATIN SMALL LETTER H

U+0069

0x69

LATIN SMALL LETTER I

U+006A

0x6A

LATIN SMALL LETTER J

U+006B

0x6B

LATIN SMALL LETTER K

U+006C

0x6C

LATIN SMALL LETTER L

U+006D

0x6D

LATIN SMALL LETTER M

U+006E

0x6E

LATIN SMALL LETTER N

U+006F

0x6F

LATIN SMALL LETTER O

U+0070

0x70

LATIN SMALL LETTER P

U+0071

0x71

LATIN SMALL LETTER Q

U+0072

0x72

LATIN SMALL LETTER R

U+0073

0x73

LATIN SMALL LETTER S

U+0074

0x74

LATIN SMALL LETTER T

U+0075

0x75

LATIN SMALL LETTER U

U+0076

0x76

LATIN SMALL LETTER V

U+0077

0x77

LATIN SMALL LETTER W

U+0078

0x78

LATIN SMALL LETTER X

U+0079

0x79

LATIN SMALL LETTER Y

U+007A

0x7A

LATIN SMALL LETTER Z

U+007B

0x7B

LEFT CURLY BRACKET

U+007C

0x7C

VERTICAL LINE

U+007D

0x7D

RIGHT CURLY BRACKET

U+007E

0x7E

TILDE

U+007F

0x7F

<control> DELETE

U+0086

0x86

<control> START OF SELECTED AREA

U+0087

0x87

<control> END OF SELECTED AREA

U+0088

0x88

<control> CHARACTER TABULATION SET

U+0089

0x89

<control> CHARACTER TABULATION WITH JUSTIFICATION

U+008A

0x8A

<control> LINE TABULATION SET

U+008B

0x8B

<control> PARTIAL LINE FORWARD

U+008C

0x8C

<control> PARTIAL LINE BACKWARD

U+008D

0x8D

<control> REVERSE LINE FEED

U+008E

0x8E

<control> SINGLE SHIFT TWO

U+008F

0x8F

<control> SINGLE SHIFT THREE

U+0090

0x90

<control> DEVICE CONTROL STRING

U+0091

0x91

<control> PRIVATE USE ONE

U+0092

0x92

<control> PRIVATE USE TWO

U+0093

0x93

<control> SET TRANSMIT RATE

U+0094

0x94

<control> CANCEL CHARACTER

U+0095

0x95

<control> MESSAGE WAITING

U+0096

0x96

<control> START OF GUARDED AREA

U+0097

0x97

<control> END OF GUARDED AREA

U+0098

0x98

<control> START OF STRING

U+0099

0x99

<control>

U+009A

0x9A

<control> SINGLE CHARACTER INTRODUCER

U+009B

0x9B

<control> CONTROL SEQUENCE INTRODUCER

U+009C

0x9C

<control> STRING TERMINATOR

U+009D

0x9D

<control> OPERATING SYSTEM COMMAND

U+009E

0x9E

<control> PRIVACY MESSAGE

U+009F

0x9F

<control> APPLICATION PROGRAM COMMAND

U+00A0

0x80

NO-BREAK SPACE

U+00A1

0xA1

INVERTED EXCLAMATION MARK

U+00A2

0xA2

CENT SIGN

U+00A3

0xA3

POUND SIGN

U+00A4

0xA8

CURRENCY SIGN

U+00A5

0xA5

YEN SIGN

U+00A6

0xA6

BROKEN BAR

U+00A7

0xA7

SECTION SIGN

U+00A8

0x81

DIAERESIS

U+00A9

0xA9

COPYRIGHT SIGN

U+00AA

0xAA

FEMININE ORDINAL INDICATOR

U+00AB

0xAB

LEFT-POINTING DOUBLE ANGLE QUOTATION MARK

U+00AC

0xAC

NOT SIGN

U+00AD

0xAD

SOFT HYPHEN

U+00AE

0xAE

REGISTERED SIGN

U+00AF

0xAF

MACRON

U+00B0

0xB0

DEGREE SIGN

U+00B1

0xB1

PLUS-MINUS SIGN

U+00B2

0xB2

SUPERSCRIPT TWO

U+00B3

0xB3

SUPERSCRIPT THREE

U+00B4

0x82

ACUTE ACCENT

U+00B5

0xB5

MICRO SIGN

U+00B6

0xB6

PILCROW SIGN

U+00B7

0xB7

MIDDLE DOT

U+00B8

0x83

CEDILLA

U+00B9

0xB9

SUPERSCRIPT ONE

U+00BA

0xBA

MASCULINE ORDINAL INDICATOR

U+00BB

0xBB

RIGHT-POINTING DOUBLE ANGLE QUOTATION MARK

U+00BC

0xBC

VULGAR FRACTION ONE QUARTER

U+00BD

0xBD

VULGAR FRACTION ONE HALF

U+00BE

0xBE

VULGAR FRACTION THREE QUARTERS

U+00BF

0xBF

INVERTED QUESTION MARK

U+00C0

0xC0

LATIN CAPITAL LETTER A WITH GRAVE

U+00C1

0xC1

LATIN CAPITAL LETTER A WITH ACUTE

U+00C2

0xC2

LATIN CAPITAL LETTER A WITH CIRCUMFLEX

U+00C3

0xC3

LATIN CAPITAL LETTER A WITH TILDE

U+00C4

0xC4

LATIN CAPITAL LETTER A WITH DIAERESIS

U+00C5

0xC5

LATIN CAPITAL LETTER A WITH RING ABOVE

U+00C6

0xC6

LATIN CAPITAL LETTER AE

U+00C7

0xC7

LATIN CAPITAL LETTER C WITH CEDILLA

U+00C8

0xC8

LATIN CAPITAL LETTER E WITH GRAVE

U+00C9

0xC9

LATIN CAPITAL LETTER E WITH ACUTE

U+00CA

0xCA

LATIN CAPITAL LETTER E WITH CIRCUMFLEX

U+00CB

0xCB

LATIN CAPITAL LETTER E WITH DIAERESIS

U+00CC

0xCC

LATIN CAPITAL LETTER I WITH GRAVE

U+00CD

0xCD

LATIN CAPITAL LETTER I WITH ACUTE

U+00CE

0xCE

LATIN CAPITAL LETTER I WITH CIRCUMFLEX

U+00CF

0xCF

LATIN CAPITAL LETTER I WITH DIAERESIS

U+00D0

0xF0

LATIN CAPITAL LETTER ETH

U+00D1

0xD1

LATIN CAPITAL LETTER N WITH TILDE

U+00D2

0xD2

LATIN CAPITAL LETTER O WITH GRAVE

U+00D3

0xD3

LATIN CAPITAL LETTER O WITH ACUTE

U+00D4

0xD4

LATIN CAPITAL LETTER O WITH CIRCUMFLEX

U+00D5

0xD5

LATIN CAPITAL LETTER O WITH TILDE

U+00D6

0xD6

LATIN CAPITAL LETTER O WITH DIAERESIS

U+00D7

0x84

MULTIPLICATION SIGN

U+00D8

0xD8

LATIN CAPITAL LETTER O WITH STROKE

U+00D9

0xD9

LATIN CAPITAL LETTER U WITH GRAVE

U+00DA

0xDA

LATIN CAPITAL LETTER U WITH ACUTE

U+00DB

0xDB

LATIN CAPITAL LETTER U WITH CIRCUMFLEX

U+00DC

0xDC

LATIN CAPITAL LETTER U WITH DIAERESIS

U+00DD

0xB4

LATIN CAPITAL LETTER Y WITH ACUTE

U+00DE

0xFE

LATIN CAPITAL LETTER THORN

U+00DF

0xDF

LATIN SMALL LETTER SHARP S

U+00E0

0xE0

LATIN SMALL LETTER A WITH GRAVE

U+00E1

0xE1

LATIN SMALL LETTER A WITH ACUTE

U+00E2

0xE2

LATIN SMALL LETTER A WITH CIRCUMFLEX

U+00E3

0xE3

LATIN SMALL LETTER A WITH TILDE

U+00E4

0xE4

LATIN SMALL LETTER A WITH DIAERESIS

U+00E5

0xE5

LATIN SMALL LETTER A WITH RING ABOVE

U+00E6

0xE6

LATIN SMALL LETTER AE

U+00E7

0xE7

LATIN SMALL LETTER C WITH CEDILLA

U+00E8

0xE8

LATIN SMALL LETTER E WITH GRAVE

U+00E9

0xE9

LATIN SMALL LETTER E WITH ACUTE

U+00EA

0xEA

LATIN SMALL LETTER E WITH CIRCUMFLEX

U+00EB

0xEB

LATIN SMALL LETTER E WITH DIAERESIS

U+00EC

0xEC

LATIN SMALL LETTER I WITH GRAVE

U+00ED

0xED

LATIN SMALL LETTER I WITH ACUTE

U+00EE

0xEE

LATIN SMALL LETTER I WITH CIRCUMFLEX

U+00EF

0xEF

LATIN SMALL LETTER I WITH DIAERESIS

U+00F0

0xD0

LATIN SMALL LETTER ETH

U+00F1

0xF1

LATIN SMALL LETTER N WITH TILDE

U+00F2

0xF2

LATIN SMALL LETTER O WITH GRAVE

U+00F3

0xF3

LATIN SMALL LETTER O WITH ACUTE

U+00F4

0xF4

LATIN SMALL LETTER O WITH CIRCUMFLEX

U+00F5

0xF5

LATIN SMALL LETTER O WITH TILDE

U+00F6

0xF6

LATIN SMALL LETTER O WITH DIAERESIS

U+00F7

0x85

DIVISION SIGN

U+00F8

0xF8

LATIN SMALL LETTER O WITH STROKE

U+00F9

0xF9

LATIN SMALL LETTER U WITH GRAVE

U+00FA

0xFA

LATIN SMALL LETTER U WITH ACUTE

U+00FB

0xFB

LATIN SMALL LETTER U WITH CIRCUMFLEX

U+00FC

0xFC

LATIN SMALL LETTER U WITH DIAERESIS

U+00FD

0xA4

LATIN SMALL LETTER Y WITH ACUTE

U+00FE

0xDE

LATIN SMALL LETTER THORN

U+00FF

0xFD

LATIN SMALL LETTER Y WITH DIAERESIS

U+0152

0xD7

LATIN CAPITAL LIGATURE OE

U+0153

0xF7

LATIN SMALL LIGATURE OE

U+0160

0xB8

LATIN CAPITAL LETTER S WITH CARON

U+0161

0xA0

LATIN SMALL LETTER S WITH CARON

U+0178

0xDD

LATIN CAPITAL LETTER Y WITH DIAERESIS

U+039C

0xB5

GREEK CAPITAL LETTER MU and MICRO SIGN

U+20AC

0xFF

EURO SIGN

U+FFFD

0x1A

REPLACEMENT CHARACTER & <control>