
Appendix A: Conversion Tables
Character translations
The charTranslate built-in function allows
you to convert between ASCII, EBCDIC, T-11 EBCDIC, and TN EBCDIC.
Table A-3: Character
translation
char
|
ASCII
|
EBCDIC
|
T-11
|
TN
|
“NUL”
|
0x00
|
0x00
|
0x00
|
0x00
|
“ACK”
|
0x06
|
0x2e
|
0x2e
|
0x2e
|
“BEL”
|
0x07
|
0x2f
|
0x2f
|
0x2f
|
“BS”
|
0x08
|
0x16
|
0x16
|
0x16
|
“BYP”
|
CTTNOT
|
0x24
|
0x24
|
0x24
|
“CAN”
|
0x18
|
0x18
|
0x18
|
0x18
|
“CR”
|
0x0d
|
0x0d
|
0x0d
|
0x0d
|
“CSP”
|
CTTNOT
|
0x2b
|
0x2b
|
0x2b
|
“CU1”
|
CTTNOT
|
0x1b
|
0x1b
|
0x1b
|
“CU3”
|
CTTNOT
|
0x3b
|
0x3b
|
0x3b
|
“DC1”
|
0x11
|
0x11
|
0x11
|
0x11
|
“DC2”
|
0x12
|
0x12
|
0x12
|
0x12
|
“DC3”
|
0x13
|
0x13
|
0x13
|
0x13
|
“DC4”
|
0x14
|
0x3c
|
0x3c
|
0x3c
|
“DEL”
|
0x7f
|
0x07
|
0x07
|
0x07
|
“DLE”
|
0x10
|
0x10
|
0x10
|
0x10
|
“DS”
|
CTTNOT
|
0x20
|
0x20
|
0x20
|
“EM”
|
0x19
|
0x19
|
0x19
|
0x19
|
“ENQ”
|
0x05
|
0x2d
|
0x2d
|
0x2d
|
“EO”
|
CTTNOT
|
0xff
|
0xff
|
0xff
|
“EOT”
|
0x04
|
0x37
|
0x37
|
0x37
|
“ESC”
|
0x1b
|
0x27
|
0x27
|
0x27
|
“ENQ”
|
0x05
|
0x2d
|
0x2d
|
0x2d
|
“ETB”
|
0x17
|
0x26
|
0x26
|
0x26
|
“ETX”
|
0x03
|
0x03
|
0x03
|
0x03
|
“FF”
|
0x0c
|
0x0c
|
0x0c
|
0x0c
|
“FS”
|
0x1c
|
0x22
|
0x22
|
0x22
|
“GE”
|
CTTNOT
|
0x08
|
0x08
|
0x08
|
“GS”
|
0x1d
|
CTTNOT
|
CTTNOT
|
CTTNOT
|
“HT”
|
0x09
|
0x05
|
0x05
|
0x05
|
“IFS”
|
CTTNOT
|
0x1c
|
0x1c
|
0x1c
|
“IGS”
|
CTTNOT
|
0x1d
|
0x1d
|
0x1d
|
“IR”
|
CTTNOT
|
0x33
|
0x33
|
0x33
|
“IRS”
|
CTTNOT
|
0x1e
|
0x1e
|
0x1e
|
“IT”
|
CTTNOT
|
0x39
|
0x39
|
0x39
|
“IUS”
|
CTTNOT
|
0x1f
|
0x1f
|
0x1f
|
“LF”
|
0x0a
|
0x25
|
0x25
|
0x25
|
“MFA”
|
CTTNOT
|
0x2c
|
0x2c
|
0x2c
|
“NAK”
|
0x15
|
0x3d
|
0x3d
|
0x3d
|
“NBS”
|
CTTNOT
|
0x36
|
0x36
|
0x36
|
“NL”
|
CTTNOT
|
0x15
|
0x15
|
0x15
|
“NSP”
|
CTTNOT
|
0xe1
|
0xe1
|
0xe1
|
“POC”
|
CTTNOT
|
0x17
|
0x17
|
0x17
|
“PP”
|
CTTNOT
|
0x34
|
0x34
|
0x34
|
“RES”
|
CTTNOT
|
0x14
|
0x14
|
0x14
|
“RFF”
|
CTTNOT
|
0x3a
|
0x3a
|
0x3a
|
“RNL”
|
CTTNOT
|
0x06
|
0x06
|
0x06
|
“RPT”
|
CTTNOT
|
0x0a
|
0x0a
|
0x0a
|
“RS”
|
0x1e
|
CTTNOT
|
CTTNOT
|
CTTNOT
|
“RSP”
|
CTTNOT
|
0x41
|
0x41
|
0x41
|
“SA”
|
CTTNOT
|
0x28
|
0x28
|
0x28
|
“SBS”
|
CTTNOT
|
0x38
|
0x38
|
0x38
|
“SEL”
|
CTTNOT
|
0x04
|
0x04
|
0x04
|
“SFE”
|
CTTNOT
|
0x29
|
0x29
|
0x29
|
“SHY”
|
CTTNOT
|
0xca
|
0xca
|
0xca
|
“SI”
|
0x0f
|
0x0f
|
0x0f
|
0x0f
|
“SM”
|
CTTNOT
|
0x2a
|
0x2a
|
0x2a
|
“SO”
|
0x0e
|
0x0e
|
0x0e
|
0x0e
|
“SOH”
|
0x01
|
0x01
|
0x01
|
0x01
|
“SOS”
|
CTTNOT
|
0x21
|
0x21
|
0x21
|
“SP”
|
0x20
|
0x40
|
0x40
|
0x40
|
“SPS”
|
CTTNOT
|
0x09
|
0x09
|
0x09
|
“STX”
|
0x02
|
0x02
|
0x02
|
0x02
|
“SUB”
|
0x1a
|
0x3f
|
0x3f
|
0x3f
|
“SYN”
|
0x16
|
0x32
|
0x32
|
0x32
|
“TRN”
|
CTTNOT
|
0x35
|
0x35
|
0x35
|
“UBS”
|
CTTNOT
|
0x1a
|
0x1a
|
0x1a
|
“US”
|
0x1f
|
CTTNOT
|
CTTNOT
|
CTTNOT
|
“VT”
|
0x0b
|
0x0b
|
0x0b
|
0x0b
|
“WUS”
|
CTTNOT
|
0x23
|
0x23
|
0x23
|
“ ! ”
|
0x21
|
0xdd
|
0x5a
|
0x5a
|
“ \ ”
|
0x22
|
CTTNOT
|
0x7f
|
0x7f
|
“ # ”
|
0x23
|
0x7b
|
0x7b
|
0x7b
|
“ $ ”
|
0x24
|
0x5b
|
0x5b
|
0x5b
|
“ % ”
|
0x25
|
0x6c
|
0x6c
|
0x6c
|
“ & ”
|
0x26
|
0x50
|
0x50
|
0x50
|
“ ‘ ”
|
0x27
|
CTTNOT
|
0x7d
|
0x7d
|
“ ( ”
|
0x28
|
0x4d
|
0x4d
|
0x4d
|
“ ) ”
|
0x29
|
0x5d
|
0x5d
|
0x5d
|
“ * ”
|
0x2a
|
0x5c
|
0x5c
|
0x5c
|
“ + ”
|
0x2b
|
CTTNOT
|
0x4e
|
0x4e
|
“ “ ”
|
0x2c
|
0x6b
|
0x6b
|
0x6b
|
“ - ”
|
0x2d
|
0x60
|
0x60
|
0x60
|
“ . ”
|
0x2e
|
0x4b
|
0x4b
|
0x4b
|
“ / ”
|
0x2f
|
0x61
|
0x61
|
0x61
|
“0”
|
0x30
|
0xf0
|
0xf0
|
0xf0
|
“1”
|
0x31
|
0xf1
|
0xf1
|
0xf1
|
“2”
|
0x32
|
0xf2
|
0xf2
|
0xf2
|
“3”
|
0x33
|
0xf3
|
0xf3
|
0xf3
|
“4”
|
0x34
|
0xf4
|
0xf4
|
0xf4
|
“5”
|
0x35
|
0xf5
|
0xf5
|
0xf5
|
“6”
|
0x36
|
0xf6
|
0xf6
|
0xf6
|
“7”
|
0x37
|
0xf7
|
0xf7
|
0xf7
|
“8”
|
0x38
|
0xf8
|
0xf8
|
0xf8
|
“9”
|
0x39
|
0xf9
|
0xf9
|
0xf9
|
“ : ”
|
0x3a
|
0x7d
|
0x7a
|
0x7a
|
“ ; ”
|
0x3b
|
0x5e
|
0x5e
|
0x5e
|
“ < ”
|
0x3c
|
0x4e
|
0x4c
|
0x4c
|
“ = ”
|
0x3d
|
CTTNOT
|
0x7e
|
0x7e
|
“ > ”
|
0x3e
|
0x7e
|
0x6e
|
0x6e
|
“ ? ”
|
0x3f
|
0xc0
|
0x6f
|
0x6f
|
“ @ ”
|
0x40
|
0x7c
|
0x7c
|
0x7c
|
“A”
|
0x41
|
0xc1
|
0xc1
|
0xc1
|
“B”
|
0x42
|
0xc2
|
0xc2
|
0xc2
|
“C”
|
0x43
|
0xc3
|
0xc3
|
0xc3
|
“D”
|
0x44
|
0xc4
|
0xc4
|
oxc4
|
“E”
|
0x45
|
0xc5
|
0xc5
|
0xc5
|
“F”
|
0x46
|
0xc6
|
0xc6
|
0xc6
|
“G”
|
0x47
|
0xc7
|
0xc7
|
0xc7
|
“H”
|
0x48
|
0xc8
|
0xc8
|
0xc8
|
“I”
|
0x49
|
0xc9
|
0xc9
|
0xc9
|
“J”
|
0x4a
|
0xd1
|
0xd1
|
0xd1
|
“K”
|
0x4b
|
0xd2
|
0xd2
|
0xd2
|
“L”
|
0x4c
|
0xd3
|
0xd3
|
0xd3
|
“M”
|
0x4d
|
0xd4
|
0xd4
|
0xd4
|
“N”
|
0x4e
|
0xd5
|
0xd5
|
0xd5
|
“O”
|
0x4f
|
0xd6
|
0xd6
|
0xd6
|
“P”
|
0x50
|
0xd7
|
0xd7
|
0xd7
|
“Q”
|
0x51
|
0xd8
|
0xd8
|
0xd8
|
“R”
|
0x52
|
0xd9
|
0xd9
|
0xd9
|
“S”
|
0x53
|
0xe2
|
0xe2
|
0xe2
|
“T”
|
0x54
|
0xe3
|
0xe3
|
0xe3
|
“U”
|
0x55
|
0xe4
|
0xe4
|
0xe4
|
“V”
|
0x56
|
0xe5
|
0xe5
|
0xe5
|
“W”
|
0x57
|
0xe6
|
0xe6
|
0xe6
|
“X”
|
0x58
|
0xe7
|
0xe7
|
0xe7
|
“Y”
|
0x59
|
0xe8
|
0xe8
|
0xe8
|
“Z”
|
0x60
|
0xe9
|
0xe9
|
0xe9
|
“ [ ”
|
0x5b
|
0xad
|
0xad
|
0xad
|
“ \ \ ”
|
0x5c
|
0x6e
|
0x0e
|
0xe0
|
“ ] ”
|
0x5d
|
0xbd
|
0xbd
|
0xbd
|
“ ^ ”
|
0x5e
|
0x5f
|
0x5f
|
0x5f
|
“ _ ”
|
0x5f
|
CTTNOT
|
0x6d
|
0x6d
|
“ ‘ ”
|
0x60
|
0x79
|
0x79
|
0x79
|
“a”
|
0x61
|
CTTNOT
|
0x81
|
0x81
|
“b”
|
0x62
|
CTTNOT
|
0x82
|
0x82
|
“c”
|
0x63
|
CTTNOT
|
0x83
|
0x83
|
“d”
|
0x64
|
CTTNOT
|
0x84
|
0x84
|
“e”
|
0x65
|
CTTNOT
|
0x85
|
0x85
|
“f”
|
0x66
|
CTTNOT
|
0x86
|
0x86
|
“g”
|
0x67
|
CTTNOT
|
0x87
|
0x87
|
“h”
|
0x68
|
CTTNOT
|
0x88
|
0x88
|
“i”
|
0x69
|
CTTNOT
|
0x89
|
0x89
|
“j”
|
0x6a
|
CTTNOT
|
0x91
|
0x91
|
“k”
|
0x6b
|
CTTNOT
|
0x92
|
0x92
|
“l”
|
0x6c
|
CTTNOT
|
0x93
|
0x93
|
“m”
|
0x6d
|
CTTNOT
|
0x94
|
0x94
|
“n”
|
0x6e
|
CTTNOT
|
0x95
|
0x95
|
“o”
|
0x6f
|
CTTNOT
|
0x96
|
0x96
|
“p”
|
0x70
|
CTTNOT
|
0x97
|
0x97
|
“q”
|
0x71
|
CTTNOT
|
0x98
|
0x98
|
“r”
|
0x72
|
CTTNOT
|
0x99
|
0x99
|
“s”
|
0x73
|
CTTNOT
|
0xa2
|
0xa2
|
“t”
|
0x74
|
CTTNOT
|
0xa3
|
0xa3
|
“u”
|
0x75
|
CTTNOT
|
0xa4
|
0xa4
|
“v”
|
0x76
|
CTTNOT
|
0xa5
|
0xa5
|
“w”
|
0x77
|
CTTNOT
|
0xa6
|
0xa6
|
“x”
|
0x78
|
CTTNOT
|
0xa7
|
0xa7
|
“y”
|
0x79
|
CTTNOT
|
0xa8
|
0xa8
|
“z”
|
0x7a
|
CTTNOT
|
0xa9
|
0xa9
|
“ ”
|
0x7b
|
CTTNOT
|
0xc0
|
0xc0
|
“ | ”
|
0x7c
|
0x6a
|
0x6a
|
0x6a
|
“ ”
|
0x7d
|
CTTNOT
|
0xd0
|
0xd0
|
“ ~ ”
|
0x7e
|
0xa1
|
0xa1
|
0xa1
|
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF 