Also, the lists of characters along with their code points used in oracle database character set WE8MSWIN1252 is defined in the http://msdn.microsoft.com/en-us/goglobal/cc305145.aspx.
If we look for WE8MSWIN1252 and WE8ISO8859P15 character set then 28 code points are not existed in WE8ISO8859P15 but they are used/filled in WE8MSWIN1252.
Also all of the characters exist in WE8ISO8859P15 are also exists in WE8MSWIN1252. So we can say WE8MSWIN1252 is a logical superset of character set WE8ISO8859P15 but not a binary superset.
Also we see 8 codepoints have a different symbol in WE8MSWIN1252 than in P15 for the same physical codepoint.
Below is the lists of all characters under both character sets along with their code points.
Dec. Unico. Charac. WE8ISO8859P15 Character Description
---- ------ ------- (States if different) -----------
0x00 0x0000 [ ] [ ] NULL
0x01 0x0001 [ ] [ ] START OF HEADING
0x02 0x0002 [ ] [ ] START OF TEXT
0x03 0x0003 [ ] [ ] END OF TEXT
0x04 0x0004 [ ] [ ] END OF TRANSMISSION
0x05 0x0005 [ ] [ ] ENQUIRY
0x06 0x0006 [ ] [ ] ACKNOWLEDGE
0x07 0x0007 [ ] [ ] BELL
0x08 0x0008 [ ] [ ] BACKSPACE
0x09 0x0009 [ ] [ ] HORIZONTAL TABULATION
0x0A 0x000A [ ] [ ] LINE FEED
0x0B 0x000B [ ] [ ] VERTICAL TABULATION
0x0C 0x000C [ ] [ ] FORM FEED
0x0D 0x000D [ ] [ ] CARRIAGE RETURN
0x0E 0x000E [ ] [ ] SHIFT OUT
0x0F 0x000F [ ] [ ] SHIFT IN
0x10 0x0010 [ ] [ ] DATA LINK ESCAPE
0x11 0x0011 [ ] [ ] DEVICE CONTROL ONE
0x12 0x0012 [ ] [ ] DEVICE CONTROL TWO
0x13 0x0013 [ ] [ ] DEVICE CONTROL THREE
0x14 0x0014 [ ] [ ] DEVICE CONTROL FOUR
0x15 0x0015 [ ] [ ] NEGATIVE ACKNOWLEDGE
0x16 0x0016 [ ] [ ] SYNCHRONOUS IDLE
0x17 0x0017 [ ] [ ] END OF TRANSMISSION BLOCK
0x18 0x0018 [ ] [ ] CANCEL
0x19 0x0019 [ ] [ ] END OF MEDIUM
0x1A 0x001A [ ] [ ] SUBSTITUTE
0x1B 0x001B [ ] [ ] ESCAPE
0x1C 0x001C [ ] [ ] FILE SEPARATOR
0x1D 0x001D [ ] [ ] GROUP SEPARATOR
0x1E 0x001E [ ] [ ] RECORD SEPARATOR
0x1F 0x001F [ ] [ ] UNIT SEPARATOR
0x20 0x0020 [ ] [ ] SPACE
0x21 0x0021 [!] [!] EXCLAMATION MARK
0x22 0x0022 ["] ["] QUOTATION MARK
0x23 0x0023 [#] [#] NUMBER SIGN
0x24 0x0024 [$] [$] DOLLAR SIGN
0x25 0x0025 [%] [%] PERCENT SIGN
0x26 0x0026 [&] [&] AMPERSAND
0x27 0x0027 ['] ['] APOSTROPHE
0x28 0x0028 [(] [(] LEFT PARENTHESIS
0x29 0x0029 [)] [)] RIGHT PARENTHESIS
0x2A 0x002A [*] [*] ASTERISK
0x2B 0x002B [+] [+] PLUS SIGN
0x2C 0x002C [,] [,] COMMA
0x2D 0x002D [-] [-] HYPHEN-MINUS
0x2E 0x002E [.] [.] FULL STOP
0x2F 0x002F [/] [/] SOLIDUS
0x30 0x0030 [0] [0] DIGIT ZERO
0x31 0x0031 [1] [1] DIGIT ONE
0x32 0x0032 [2] [2] DIGIT TWO
0x33 0x0033 [3] [3] DIGIT THREE
0x34 0x0034 [4] [4] DIGIT FOUR
0x35 0x0035 [5] [5] DIGIT FIVE
0x36 0x0036 [6] [6] DIGIT SIX
0x37 0x0037 [7] [7] DIGIT SEVEN
0x38 0x0038 [8] [8] DIGIT EIGHT
0x39 0x0039 [9] [9] DIGIT NINE
0x3A 0x003A [:] [:] COLON
0x3B 0x003B [;] [;] SEMICOLON
0x3C 0x003C [<] [<] LESS-THAN SIGN 0x3D 0x003D [=] [=] EQUALS SIGN 0x3E 0x003E [>] [>] GREATER-THAN SIGN
0x3F 0x003F [?] [?] QUESTION MARK
0x40 0x0040 [@] [@] COMMERCIAL AT
0x41 0x0041 [A] [A] LATIN CAPITAL LETTER A
0x42 0x0042 [B] [B] LATIN CAPITAL LETTER B
0x43 0x0043 [C] [C] LATIN CAPITAL LETTER C
0x44 0x0044 [D] [D] LATIN CAPITAL LETTER D
0x45 0x0045 [E] [E] LATIN CAPITAL LETTER E
0x46 0x0046 [F] [F] LATIN CAPITAL LETTER F
0x47 0x0047 [G] [G] LATIN CAPITAL LETTER G
0x48 0x0048 [H] [H] LATIN CAPITAL LETTER H
0x49 0x0049 [I] [I] LATIN CAPITAL LETTER I
0x4A 0x004A [J] [J] LATIN CAPITAL LETTER J
0x4B 0x004B [K] [K] LATIN CAPITAL LETTER K
0x4C 0x004C [L] [L] LATIN CAPITAL LETTER L
0x4D 0x004D [M] [M] LATIN CAPITAL LETTER M
0x4E 0x004E [N] [N] LATIN CAPITAL LETTER N
0x4F 0x004F [O] [O] LATIN CAPITAL LETTER O
0x50 0x0050 [P] [P] LATIN CAPITAL LETTER P
0x51 0x0051 [Q] [Q] LATIN CAPITAL LETTER Q
0x52 0x0052 [R] [R] LATIN CAPITAL LETTER R
0x53 0x0053 [S] [S] LATIN CAPITAL LETTER S
0x54 0x0054 [T] [T] LATIN CAPITAL LETTER T
0x55 0x0055 [U] [U] LATIN CAPITAL LETTER U
0x56 0x0056 [V] [V] LATIN CAPITAL LETTER V
0x57 0x0057 [W] [W] LATIN CAPITAL LETTER W
0x58 0x0058 [X] [X] LATIN CAPITAL LETTER X
0x59 0x0059 [Y] [Y] LATIN CAPITAL LETTER Y
0x5A 0x005A [Z] [Z] LATIN CAPITAL LETTER Z
0x5B 0x005B [[] [[] LEFT SQUARE BRACKET
0x5C 0x005C [\] [\] REVERSE SOLIDUS
0x5D 0x005D []] []] RIGHT SQUARE BRACKET
0x5E 0x005E [^] [^] CIRCUMFLEX ACCENT
0x5F 0x005F [_] [_] LOW LINE
0x60 0x0060 [`] [`] GRAVE ACCENT
0x61 0x0061 [a] [a] LATIN SMALL LETTER A
0x62 0x0062 [b] [b] LATIN SMALL LETTER B
0x63 0x0063 [c] [c] LATIN SMALL LETTER C
0x64 0x0064 [d] [d] LATIN SMALL LETTER D
0x65 0x0065 [e] [e] LATIN SMALL LETTER E
0x66 0x0066 [f] [f] LATIN SMALL LETTER F
0x67 0x0067 [g] [g] LATIN SMALL LETTER G
0x68 0x0068 [h] [h] LATIN SMALL LETTER H
0x69 0x0069 [i] [i] LATIN SMALL LETTER I
0x6A 0x006A [j] [j] LATIN SMALL LETTER J
0x6B 0x006B [k] [k] LATIN SMALL LETTER K
0x6C 0x006C [l] [l] LATIN SMALL LETTER L
0x6D 0x006D [m] [m] LATIN SMALL LETTER M
0x6E 0x006E [n] [n] LATIN SMALL LETTER N
0x6F 0x006F [o] [o] LATIN SMALL LETTER O
0x70 0x0070 [p] [p] LATIN SMALL LETTER P
0x71 0x0071 [q] [q] LATIN SMALL LETTER Q
0x72 0x0072 [r] [r] LATIN SMALL LETTER R
0x73 0x0073 [s] [s] LATIN SMALL LETTER S
0x74 0x0074 [t] [t] LATIN SMALL LETTER T
0x75 0x0075 [u] [u] LATIN SMALL LETTER U
0x76 0x0076 [v] [v] LATIN SMALL LETTER V
0x77 0x0077 [w] [w] LATIN SMALL LETTER W
0x78 0x0078 [x] [x] LATIN SMALL LETTER X
0x79 0x0079 [y] [y] LATIN SMALL LETTER Y
0x7A 0x007A [z] [z] LATIN SMALL LETTER Z
0x7B 0x007B [{] [{] LEFT CURLY BRACKET
0x7C 0x007C [|] [|] VERTICAL LINE
0x7D 0x007D [}] [}] RIGHT CURLY BRACKET
0x7E 0x007E [~] [~] TILDE
0x7F 0x007F [ ] [ ] DELETE
0x80 0x20AC [€] [€] UNDEFINED EURO SIGN
0x81 [ ] [ ] UNDEFINED UNDEFINED
0x82 0x201A [‚] [‚] UNDEFINED SINGLE LOW-9 QUOTATION MARK
0x83 0x0192 [ƒ] [ƒ] UNDEFINED LATIN SMALL LETTER F WITH HOOK
0x84 0x201E [„] [„] UNDEFINED DOUBLE LOW-9 QUOTATION MARK
0x85 0x2026 […] […] UNDEFINED HORIZONTAL ELLIPSIS
0x86 0x2020 [†] [†] UNDEFINED DAGGER
0x87 0x2021 [‡] [‡] UNDEFINED DOUBLE DAGGER
0x88 0x02C6 [ˆ] [ˆ] UNDEFINED MODIFIER LETTER CIRCUMFLEX ACCENT
0x89 0x2030 [‰] [‰] UNDEFINED PER MILLE SIGN
0x8A 0x0160 [Š] [Š] UNDEFINED LATIN CAPITAL LETTER S WITH CARON
0x8B 0x2039 [‹] [‹] UNDEFINED SINGLE LEFT-POINTING ANGLE QUOTATION MARK
0x8C 0x0152 [Œ] [Œ] UNDEFINED LATIN CAPITAL LIGATURE OE
0x8D [ ] [ ] UNDEFINED UNDEFINED
0x8E 0x017D [Ž] [Ž] UNDEFINED LATIN CAPITAL LETTER Z WITH CARON
0x8F [ ] [ ] UNDEFINED UNDEFINED
0x90 [ ] [ ] UNDEFINED UNDEFINED
0x91 0x2018 [‘] [‘] UNDEFINED LEFT SINGLE QUOTATION MARK
0x92 0x2019 [’] [’] UNDEFINED RIGHT SINGLE QUOTATION MARK
0x93 0x201C [“] [“] UNDEFINED LEFT DOUBLE QUOTATION MARK
0x94 0x201D [”] [”] UNDEFINED RIGHT DOUBLE QUOTATION MARK
0x95 0x2022 [•] [•] UNDEFINED BULLET
0x96 0x2013 [–] [–] UNDEFINED EN DASH
0x97 0x2014 [—] [—] UNDEFINED EM DASH
0x98 0x02DC [˜] [˜] UNDEFINED SMALL TILDE
0x99 0x2122 [™] [™] UNDEFINED TRADE MARK SIGN
0x9A 0x0161 [š] [š] UNDEFINED LATIN SMALL LETTER S WITH CARON
0x9B 0x203A [›] [›] UNDEFINED SINGLE RIGHT-POINTING ANGLE QUOTATION MARK
0x9C 0x0153 [œ] [œ] UNDEFINED LATIN SMALL LIGATURE OE
0x9D [ ] [ ] UNDEFINED UNDEFINED
0x9E 0x017E [ž] [ž] UNDEFINED LATIN SMALL LETTER Z WITH CARON
0x9F 0x0178 [Ÿ] [Ÿ] UNDEFINED LATIN CAPITAL LETTER Y WITH DIAERESIS
0xA0 0x00A0 [ ] [ ] NO-BREAK SPACE
0xA1 0x00A1 [¡] [¡] INVERTED EXCLAMATION MARK
0xA2 0x00A2 [¢] [¢] CENT SIGN
0xA3 0x00A3 [£] [£] POUND SIGN
0xA4 0x00A4 [¤] [¤] Euro Sign(€) MS1252 code point 80 CURRENCY SIGN
0xA5 0x00A5 [¥] [¥] YEN SIGN
0xA6 0x00A6 [¦] [¦] LATIN CAPITAL LETTER S WITH CARON(Š) 8A BROKEN BAR
0xA7 0x00A7 [§] [§] SECTION SIGN
0xA8 0x00A8 [¨] [¨] LATIN SMALL LETTER S WITH CARON(š) 9A DIAERESIS
0xA9 0x00A9 [©] [©] COPYRIGHT SIGN
0xAA 0x00AA [ª] [ª] FEMININE ORDINAL INDICATOR
0xAB 0x00AB [«] [«] LEFT-POINTING DOUBLE ANGLE QUOTATION MARK
0xAC 0x00AC [¬] [¬] NOT SIGN
0xAD 0x00AD [ ] [ ] SOFT HYPHEN
0xAE 0x00AE [®] [®] REGISTERED SIGN
0xAF 0x00AF [¯] [¯] MACRON
0xB0 0x00B0 [°] [°] DEGREE SIGN
0xB1 0x00B1 [±] [±] PLUS-MINUS SIGN
0xB2 0x00B2 [²] [²] SUPERSCRIPT TWO
0xB3 0x00B3 [³] [³] SUPERSCRIPT THREE
0xB4 0x00B4 [´] [´] LATIN CAPITAL LETTER Z WITH CARON(Ž) 8E ACUTE ACCENT
0xB5 0x00B5 [µ] [µ] MICRO SIGN
0xB6 0x00B6 [¶] [¶] PILCROW SIGN
0xB7 0x00B7 [·] [·] MIDDLE DOT
0xB8 0x00B8 [¸] [¸] LATIN SMALL LETTER Z WITH CARON(ž) 9E CEDILLA
0xB9 0x00B9 [¹] [¹] SUPERSCRIPT ONE
0xBA 0x00BA [º] [º] MASCULINE ORDINAL INDICATOR
0xBB 0x00BB [»] [»] RIGHT-POINTING DOUBLE ANGLE QUOTATION MARK
0xBC 0x00BC [¼] [¼] LATIN CAPITAL LIGATURE OE(Œ) 8C VULGAR FRACTION ONE QUARTER
0xBD 0x00BD [½] [½] LATIN SMALL LIGATURE OE(œ) 9C VULGAR FRACTION ONE HALF
0xBE 0x00BE [¾] [¾] LATIN CAPITAL LETTER Y WITH DIAERESIS(Ÿ) 9F VULGAR FRACTION THREE QUARTERS
0xBF 0x00BF [¿] [¿] INVERTED QUESTION MARK
0xC0 0x00C0 [À] [À] LATIN CAPITAL LETTER A WITH GRAVE
0xC1 0x00C1 [Á] [Á] LATIN CAPITAL LETTER A WITH ACUTE
0xC2 0x00C2 [Â] [Â] LATIN CAPITAL LETTER A WITH CIRCUMFLEX
0xC3 0x00C3 [Ã] [Ã] LATIN CAPITAL LETTER A WITH TILDE
0xC4 0x00C4 [Ä] [Ä] LATIN CAPITAL LETTER A WITH DIAERESIS
0xC5 0x00C5 [Å] [Å] LATIN CAPITAL LETTER A WITH RING ABOVE
0xC6 0x00C6 [Æ] [Æ] LATIN CAPITAL LETTER AE
0xC7 0x00C7 [Ç] [Ç] LATIN CAPITAL LETTER C WITH CEDILLA
0xC8 0x00C8 [È] [È] LATIN CAPITAL LETTER E WITH GRAVE
0xC9 0x00C9 [É] [É] LATIN CAPITAL LETTER E WITH ACUTE
0xCA 0x00CA [Ê] [Ê] LATIN CAPITAL LETTER E WITH CIRCUMFLEX
0xCB 0x00CB [Ë] [Ë] LATIN CAPITAL LETTER E WITH DIAERESIS
0xCC 0x00CC [Ì] [Ì] LATIN CAPITAL LETTER I WITH GRAVE
0xCD 0x00CD [Í] [Í] LATIN CAPITAL LETTER I WITH ACUTE
0xCE 0x00CE [Î] [Î] LATIN CAPITAL LETTER I WITH CIRCUMFLEX
0xCF 0x00CF [Ï] [Ï] LATIN CAPITAL LETTER I WITH DIAERESIS
0xD0 0x00D0 [Ð] [Ð] LATIN CAPITAL LETTER ETH
0xD1 0x00D1 [Ñ] [Ñ] LATIN CAPITAL LETTER N WITH TILDE
0xD2 0x00D2 [Ò] [Ò] LATIN CAPITAL LETTER O WITH GRAVE
0xD3 0x00D3 [Ó] [Ó] LATIN CAPITAL LETTER O WITH ACUTE
0xD4 0x00D4 [Ô] [Ô] LATIN CAPITAL LETTER O WITH CIRCUMFLEX
0xD5 0x00D5 [Õ] [Õ] LATIN CAPITAL LETTER O WITH TILDE
0xD6 0x00D6 [Ö] [Ö] LATIN CAPITAL LETTER O WITH DIAERESIS
0xD7 0x00D7 [×] [×] MULTIPLICATION SIGN
0xD8 0x00D8 [Ø] [Ø] LATIN CAPITAL LETTER O WITH STROKE
0xD9 0x00D9 [Ù] [Ù] LATIN CAPITAL LETTER U WITH GRAVE
0xDA 0x00DA [Ú] [Ú] LATIN CAPITAL LETTER U WITH ACUTE
0xDB 0x00DB [Û] [Û] LATIN CAPITAL LETTER U WITH CIRCUMFLEX
0xDC 0x00DC [Ü] [Ü] LATIN CAPITAL LETTER U WITH DIAERESIS
0xDD 0x00DD [Ý] [Ý] LATIN CAPITAL LETTER Y WITH ACUTE
0xDE 0x00DE [Þ] [Þ] LATIN CAPITAL LETTER THORN
0xDF 0x00DF [ß] [ß] LATIN SMALL LETTER SHARP S
0xE0 0x00E0 [à] [à] LATIN SMALL LETTER A WITH GRAVE
0xE1 0x00E1 [á] [á] LATIN SMALL LETTER A WITH ACUTE
0xE2 0x00E2 [â] [â] LATIN SMALL LETTER A WITH CIRCUMFLEX
0xE3 0x00E3 [ã] [ã] LATIN SMALL LETTER A WITH TILDE
0xE4 0x00E4 [ä] [ä] LATIN SMALL LETTER A WITH DIAERESIS
0xE5 0x00E5 [å] [å] LATIN SMALL LETTER A WITH RING ABOVE
0xE6 0x00E6 [æ] [æ] LATIN SMALL LETTER AE
0xE7 0x00E7 [ç] [ç] LATIN SMALL LETTER C WITH CEDILLA
0xE8 0x00E8 [è] [è] LATIN SMALL LETTER E WITH GRAVE
0xE9 0x00E9 [é] [é] LATIN SMALL LETTER E WITH ACUTE
0xEA 0x00EA [ê] [ê] LATIN SMALL LETTER E WITH CIRCUMFLEX
0xEB 0x00EB [ë] [ë] LATIN SMALL LETTER E WITH DIAERESIS
0xEC 0x00EC [ì] [ì] LATIN SMALL LETTER I WITH GRAVE
0xED 0x00ED [í] [í] LATIN SMALL LETTER I WITH ACUTE
0xEE 0x00EE [î] [î] LATIN SMALL LETTER I WITH CIRCUMFLEX
0xEF 0x00EF [ï] [ï] LATIN SMALL LETTER I WITH DIAERESIS
0xF0 0x00F0 [ð] [ð] LATIN SMALL LETTER ETH
0xF1 0x00F1 [ñ] [ñ] LATIN SMALL LETTER N WITH TILDE
0xF2 0x00F2 [ò] [ò] LATIN SMALL LETTER O WITH GRAVE
0xF3 0x00F3 [ó] [ó] LATIN SMALL LETTER O WITH ACUTE
0xF4 0x00F4 [ô] [ô] LATIN SMALL LETTER O WITH CIRCUMFLEX
0xF5 0x00F5 [õ] [õ] LATIN SMALL LETTER O WITH TILDE
0xF6 0x00F6 [ö] [ö] LATIN SMALL LETTER O WITH DIAERESIS
0xF7 0x00F7 [÷] [÷] DIVISION SIGN
0xF8 0x00F8 [ø] [ø] LATIN SMALL LETTER O WITH STROKE
0xF9 0x00F9 [ù] [ù] LATIN SMALL LETTER U WITH GRAVE
0xFA 0x00FA [ú] [ú] LATIN SMALL LETTER U WITH ACUTE
0xFB 0x00FB [û] [û] LATIN SMALL LETTER U WITH CIRCUMFLEX
0xFC 0x00FC [ü] [ü] LATIN SMALL LETTER U WITH DIAERESIS
0xFD 0x00FD [ý] [ý] LATIN SMALL LETTER Y WITH ACUTE
0xFE 0x00FE [þ] [þ] LATIN SMALL LETTER THORN
0xFF 0x00FF [ÿ] [ÿ] LATIN SMALL LETTER Y WITH DIAERESIS
Related Documents
http://arjudba.blogspot.com/2009/03/difference-between-we8iso8859p1-and.html
http://arjudba.blogspot.com/2009/03/difference-between-we8iso8859p1-and_11.html
No comments:
Post a Comment