15.10 - UNICODE to KanjiShiftJIS Single-Byte - 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

Teradata Database uses the mapping in the following table for the following conversions:

  • Internal to internal conversion of the UNICODE server character set to the single-byte portion of the KANJISJIS server character set.
  • Internal to external conversion of the UNICODE server character set to the single-byte portion of the KANJISJIS_0S client character set
  •  

    UNICODE

    KanjiShiftJIS Single-Byte

    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+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+00A5

    0x5C

    YEN SIGN

    U+203E

    0x7E

    OVERLINE

    U+FF61

    0xA1

    HALFWIDTH IDEOGRAPHIC FULL STOP

    U+FF62

    0xA2

    HALFWIDTH LEFT CORNER BRACKET

    U+FF63

    0xA3

    HALFWIDTH RIGHT CORNER BRACKET

    U+FF64

    0xA4

    HALFWIDTH IDEOGRAPHIC COMMA

    U+FF65

    0xA5

    HALFWIDTH KATAKANA MIDDLE DOT

    U+FF66

    0xA6

    HALFWIDTH KATAKANA LETTER WO

    U+FF67

    0xA7

    HALFWIDTH KATAKANA LETTER SMALL A

    U+FF68

    0xA8

    HALFWIDTH KATAKANA LETTER SMALL I

    U+FF69

    0xA9

    HALFWIDTH KATAKANA LETTER SMALL U

    U+FF6A

    0xAA

    HALFWIDTH KATAKANA LETTER SMALL E

    U+FF6B

    0xAB

    HALFWIDTH KATAKANA LETTER SMALL O

    U+FF6C

    0xAC

    HALFWIDTH KATAKANA LETTER SMALL YA

    U+FF6D

    0xAD

    HALFWIDTH KATAKANA LETTER SMALL YU

    U+FF6E

    0xAE

    HALFWIDTH KATAKANA LETTER SMALL YO

    U+FF6F

    0xAF

    HALFWIDTH KATAKANA LETTER SMALL TU

    U+FF70

    0xB0

    HALFWIDTH KATAKANA-HIRAGANA PROLONGED SOUND MARK

    U+FF71

    0xB1

    HALFWIDTH KATAKANA LETTER A

    U+FF72

    0xB2

    HALFWIDTH KATAKANA LETTER I

    U+FF73

    0xB3

    HALFWIDTH KATAKANA LETTER U

    U+FF74

    0xB4

    HALFWIDTH KATAKANA LETTER E

    U+FF75

    0xB5

    HALFWIDTH KATAKANA LETTER O

    U+FF76

    0xB6

    HALFWIDTH KATAKANA LETTER KA

    U+FF77

    0xB7

    HALFWIDTH KATAKANA LETTER KI

    U+FF78

    0xB8

    HALFWIDTH KATAKANA LETTER KU

    U+FF79

    0xB9

    HALFWIDTH KATAKANA LETTER KE

    U+FF7A

    0xBA

    HALFWIDTH KATAKANA LETTER KO

    U+FF7B

    0xBB

    HALFWIDTH KATAKANA LETTER SA

    U+FF7C

    0xBC

    HALFWIDTH KATAKANA LETTER SI

    U+FF7D

    0xBD

    HALFWIDTH KATAKANA LETTER SU

    U+FF7E

    0xBE

    HALFWIDTH KATAKANA LETTER SE

    U+FF7F

    0xBF

    HALFWIDTH KATAKANA LETTER SO

    U+FF80

    0xC0

    HALFWIDTH KATAKANA LETTER TA

    U+FF81

    0xC1

    HALFWIDTH KATAKANA LETTER TI

    U+FF82

    0xC2

    HALFWIDTH KATAKANA LETTER TU

    U+FF83

    0xC3

    HALFWIDTH KATAKANA LETTER TE

    U+FF84

    0xC4

    HALFWIDTH KATAKANA LETTER TO

    U+FF85

    0xC5

    HALFWIDTH KATAKANA LETTER NA

    U+FF86

    0xC6

    HALFWIDTH KATAKANA LETTER NI

    U+FF87

    0xC7

    HALFWIDTH KATAKANA LETTER NU

    U+FF88

    0xC8

    HALFWIDTH KATAKANA LETTER NE

    U+FF89

    0xC9

    HALFWIDTH KATAKANA LETTER NO

    U+FF8A

    0xCA

    HALFWIDTH KATAKANA LETTER HA

    U+FF8B

    0xCB

    HALFWIDTH KATAKANA LETTER HI

    U+FF8C

    0xCC

    HALFWIDTH KATAKANA LETTER HU

    U+FF8D

    0xCD

    HALFWIDTH KATAKANA LETTER HE

    U+FF8E

    0xCE

    HALFWIDTH KATAKANA LETTER HO

    U+FF8F

    0xCF

    HALFWIDTH KATAKANA LETTER MA

    U+FF90

    0xD0

    HALFWIDTH KATAKANA LETTER MI

    U+FF91

    0xD1

    HALFWIDTH KATAKANA LETTER MU

    U+FF92

    0xD2

    HALFWIDTH KATAKANA LETTER ME

    U+FF93

    0xD3

    HALFWIDTH KATAKANA LETTER MO

    U+FF94

    0xD4

    HALFWIDTH KATAKANA LETTER YA

    U+FF95

    0xD5

    HALFWIDTH KATAKANA LETTER YU

    U+FF96

    0xD6

    HALFWIDTH KATAKANA LETTER YO

    U+FF97

    0xD7

    HALFWIDTH KATAKANA LETTER RA

    U+FF98

    0xD8

    HALFWIDTH KATAKANA LETTER RI

    U+FF99

    0xD9

    HALFWIDTH KATAKANA LETTER RU

    U+FF9A

    0xDA

    HALFWIDTH KATAKANA LETTER RE

    U+FF9B

    0xDB

    HALFWIDTH KATAKANA LETTER RO

    U+FF9C

    0xDC

    HALFWIDTH KATAKANA LETTER WA

    U+FF9D

    0xDD

    HALFWIDTH KATAKANA LETTER N

    U+FF9E

    0xDE

    HALFWIDTH KATAKANA VOICED SOUND MARK

    U+FF9F

    0xDF

    HALFWIDTH KATAKANA SEMI-VOICED SOUND MARK

    U+FFFD

    0x1A

    REPLACEMENT CHARACTER & <control>