UTF8 Characters that can be used in Banner at Reed
Note: This is a page for administrative staff with permission to use Banner.
- UTF8 Character Set
- Inserting Special Characters in Banner
- Converting csv Files with UTF8 Data for Excel on the Mac
- Additional Assistance
The Banner database is capable of handling most special characters from the UTF8 character set.
The shared name fields (SPRIDEN) and the fields in the Student module that store the thesis titles (SHRQPNM) are the only places where special characters should be used.
Below is the set of UTF8 characters, which includes the ISO basic Latin alphabet (which I'll refer to as ASCII characters). Also listed are all the non-ASCII accented characters that are allowed in the UTF8 database.
In the "translation to the ASCII character set in SPRIDEN search field" column, you'll see how the Banner name search will treat the special character. For example: an accented, lower-case "e" ("é") will be treated like "E" in the search fields.
Therefore, searching for "Cesar" in a name search field will look at all names with "Cesar" or "César" in them and treat them as if they were "CESAR" and that's what you were searching for, so you'll find anyone with the name of "Cesar" or "César"; similarly, searching for "César" will find you anyone whose name is spelled "Cesar" or "César".
UTF8 Character Set
Unicode code point |
character | translation to the ASCII character set in SPRIDEN search fields | UTF-8 (hex.) |
name |
U+0020 | 20 | SPACE | ||
U+0021 | ! | 21 | EXCLAMATION MARK | |
U+0022 | " | 22 | QUOTATION MARK | |
U+0023 | # | 23 | NUMBER SIGN | |
U+0024 | $ | 24 | DOLLAR SIGN | |
U+0025 | 0% | 0 | 25 | PERCENT SIGN |
U+0026 | & | 26 | AMPERSAND | |
U+0027 | 27 | APOSTROPHE | ||
U+0028 | ( | 28 | LEFT PARENTHESIS | |
U+0029 | ) | 29 | RIGHT PARENTHESIS | |
U+002A | * | 2a | ASTERISK | |
U+002B | + | 2b | PLUS SIGN | |
U+002C | , | 2c | COMMA | |
U+002D | - | 2d | HYPHEN-MINUS | |
U+002E | . | 2e | FULL STOP | |
U+002F | / | 2f | SOLIDUS | |
U+0030 | 0 | 0 | 30 | DIGIT ZERO |
U+0031 | 1 | 1 | 31 | DIGIT ONE |
U+0032 | 2 | 2 | 32 | DIGIT TWO |
U+0033 | 3 | 3 | 33 | DIGIT THREE |
U+0034 | 4 | 4 | 34 | DIGIT FOUR |
U+0035 | 5 | 5 | 35 | DIGIT FIVE |
U+0036 | 6 | 6 | 36 | DIGIT SIX |
U+0037 | 7 | 7 | 37 | DIGIT SEVEN |
U+0038 | 8 | 8 | 38 | DIGIT EIGHT |
U+0039 | 9 | 9 | 39 | DIGIT NINE |
U+003A | : | 3a | COLON | |
U+003B | ; | 3b | SEMICOLON | |
U+003C | < | 3c | LESS-THAN SIGN | |
U+003D | = | 3d | EQUALS SIGN | |
U+003E | > | 3e | GREATER-THAN SIGN | |
U+003F | ? | 3f | QUESTION MARK | |
U+0040 | @ | 40 | COMMERCIAL AT | |
U+0041 | A | A | 41 | LATIN CAPITAL LETTER A |
U+0042 | B | B | 42 | LATIN CAPITAL LETTER B |
U+0043 | C | C | 43 | LATIN CAPITAL LETTER C |
U+0044 | D | D | 44 | LATIN CAPITAL LETTER D |
U+0045 | E | E | 45 | LATIN CAPITAL LETTER E |
U+0046 | F | F | 46 | LATIN CAPITAL LETTER F |
U+0047 | G | G | 47 | LATIN CAPITAL LETTER G |
U+0048 | H | H | 48 | LATIN CAPITAL LETTER H |
U+0049 | I | I | 49 | LATIN CAPITAL LETTER I |
U+004A | J | J | 4a | LATIN CAPITAL LETTER J |
U+004B | K | K | 4b | LATIN CAPITAL LETTER K |
U+004C | L | L | 4c | LATIN CAPITAL LETTER L |
U+004D | M | M | 4d | LATIN CAPITAL LETTER M |
U+004E | N | N | 4e | LATIN CAPITAL LETTER N |
U+004F | O | O | 4f | LATIN CAPITAL LETTER O |
U+0050 | P | P | 50 | LATIN CAPITAL LETTER P |
U+0051 | Q | Q | 51 | LATIN CAPITAL LETTER Q |
U+0052 | R | R | 52 | LATIN CAPITAL LETTER R |
U+0053 | S | S | 53 | LATIN CAPITAL LETTER S |
U+0054 | T | T | 54 | LATIN CAPITAL LETTER T |
U+0055 | U | U | 55 | LATIN CAPITAL LETTER U |
U+0056 | V | V | 56 | LATIN CAPITAL LETTER V |
U+0057 | W | W | 57 | LATIN CAPITAL LETTER W |
U+0058 | X | X | 58 | LATIN CAPITAL LETTER X |
U+0059 | Y | Y | 59 | LATIN CAPITAL LETTER Y |
U+005A | Z | Z | 5a | LATIN CAPITAL LETTER Z |
U+005B | [ | 5b | LEFT SQUARE BRACKET | |
U+005C | \ | 5c | REVERSE SOLIDUS | |
U+005D | ] | 5d | RIGHT SQUARE BRACKET | |
U+005E | ^ | 5e | CIRCUMFLEX ACCENT | |
U+005F | _ | 5f | LOW LINE | |
U+0060 | ` | 60 | GRAVE ACCENT | |
U+0061 | a | A | 61 | LATIN SMALL LETTER A |
U+0062 | b | B | 62 | LATIN SMALL LETTER B |
U+0063 | c | C | 63 | LATIN SMALL LETTER C |
U+0064 | d | D | 64 | LATIN SMALL LETTER D |
U+0065 | e | E | 65 | LATIN SMALL LETTER E |
U+0066 | f | F | 66 | LATIN SMALL LETTER F |
U+0067 | g | G | 67 | LATIN SMALL LETTER G |
U+0068 | h | H | 68 | LATIN SMALL LETTER H |
U+0069 | i | I | 69 | LATIN SMALL LETTER I |
U+006A | j | J | 6a | LATIN SMALL LETTER J |
U+006B | k | K | 6b | LATIN SMALL LETTER K |
U+006C | l | L | 6c | LATIN SMALL LETTER L |
U+006D | m | M | 6d | LATIN SMALL LETTER M |
U+006E | n | N | 6e | LATIN SMALL LETTER N |
U+006F | o | O | 6f | LATIN SMALL LETTER O |
U+0070 | p | P | 70 | LATIN SMALL LETTER P |
U+0071 | q | Q | 71 | LATIN SMALL LETTER Q |
U+0072 | r | R | 72 | LATIN SMALL LETTER R |
U+0073 | s | S | 73 | LATIN SMALL LETTER S |
U+0074 | t | T | 74 | LATIN SMALL LETTER T |
U+0075 | u | U | 75 | LATIN SMALL LETTER U |
U+0076 | v | V | 76 | LATIN SMALL LETTER V |
U+0077 | w | W | 77 | LATIN SMALL LETTER W |
U+0078 | x | X | 78 | LATIN SMALL LETTER X |
U+0079 | y | Y | 79 | LATIN SMALL LETTER Y |
U+007A | z | Z | 7a | LATIN SMALL LETTER Z |
U+007B | { | 7b | LEFT CURLY BRACKET | |
U+007C | | | 7c | VERTICAL LINE | |
U+007D | } | 7d | RIGHT CURLY BRACKET | |
U+007E | ~ | 7e | TILDE | |
U+00A0 | c2 a0 | NO-BREAK SPACE | ||
U+00A1 | ¡ | ¡ | c2 a1 | INVERTED EXCLAMATION MARK |
U+00A2 | ¢ | ¢ | c2 a2 | CENT SIGN |
U+00A3 | £ | £ | c2 a3 | POUND SIGN |
U+00A4 | ¤ | ¤ | c2 a4 | CURRENCY SIGN |
U+00A5 | ¥ | ¥ | c2 a5 | YEN SIGN |
U+00A6 | ¦ | ¦ | c2 a6 | BROKEN BAR |
U+00A7 | § | § | c2 a7 | SECTION SIGN |
U+00A8 | ¨ | ¨ | c2 a8 | DIAERESIS |
U+00A9 | © | © | c2 a9 | COPYRIGHT SIGN |
U+00AA | ª | ª | c2 aa | FEMININE ORDINAL INDICATOR |
U+00AB | « | « | c2 ab | LEFT-POINTING DOUBLE ANGLE QUOTATION MARK |
U+00AC | ¬ | ¬ | c2 ac | NOT SIGN |
U+00AD | | | c2 ad | SOFT HYPHEN |
U+00AE | ® | ® | c2 ae | REGISTERED SIGN |
U+00AF | ¯ | ¯ | c2 af | MACRON |
U+00B0 | ° | ° | c2 b0 | DEGREE SIGN |
U+00B1 | ± | ± | c2 b1 | PLUS-MINUS SIGN |
U+00B2 | ² | ² | c2 b2 | SUPERSCRIPT TWO |
U+00B3 | ³ | ³ | c2 b3 | SUPERSCRIPT THREE |
U+00B4 | ´ | ´ | c2 b4 | ACUTE ACCENT |
U+00B5 | µ | Μ | c2 b5 | MICRO SIGN |
U+00B6 | ¶ | ¶ | c2 b6 | PILCROW SIGN |
U+00B7 | · | · | c2 b7 | MIDDLE DOT |
U+00B8 | ¸ | ¸ | c2 b8 | CEDILLA |
U+00B9 | ¹ | ¹ | c2 b9 | SUPERSCRIPT ONE |
U+00BA | º | º | c2 ba | MASCULINE ORDINAL INDICATOR |
U+00BB | » | » | c2 bb | RIGHT-POINTING DOUBLE ANGLE QUOTATION MARK |
U+00BC | ¼ | ¼ | c2 bc | VULGAR FRACTION ONE QUARTER |
U+00BD | ½ | ½ | c2 bd | VULGAR FRACTION ONE HALF |
U+00BE | ¾ | ¾ | c2 be | VULGAR FRACTION THREE QUARTERS |
U+00BF | ¿ | ¿ | c2 bf | INVERTED QUESTION MARK |
U+00C0 | À | A | c3 80 | LATIN CAPITAL LETTER A WITH GRAVE |
U+00C1 | Á | A | c3 81 | LATIN CAPITAL LETTER A WITH ACUTE |
U+00C2 | Â | A | c3 82 | LATIN CAPITAL LETTER A WITH CIRCUMFLEX |
U+00C3 | Ã | A | c3 83 | LATIN CAPITAL LETTER A WITH TILDE |
U+00C4 | Ä | A | c3 84 | LATIN CAPITAL LETTER A WITH DIAERESIS |
U+00C5 | Å | A | c3 85 | LATIN CAPITAL LETTER A WITH RING ABOVE |
U+00C6 | Æ | A | c3 86 | LATIN CAPITAL LETTER AE |
U+00C7 | Ç | C | c3 87 | LATIN CAPITAL LETTER C WITH CEDILLA |
U+00C8 | È | E | c3 88 | LATIN CAPITAL LETTER E WITH GRAVE |
U+00C9 | É | E | c3 89 | LATIN CAPITAL LETTER E WITH ACUTE |
U+00CA | Ê | E | c3 8a | LATIN CAPITAL LETTER E WITH CIRCUMFLEX |
U+00CB | Ë | E | c3 8b | LATIN CAPITAL LETTER E WITH DIAERESIS |
U+00CC | Ì | I | c3 8c | LATIN CAPITAL LETTER I WITH GRAVE |
U+00CD | Í | I | c3 8d | LATIN CAPITAL LETTER I WITH ACUTE |
U+00CE | Î | I | c3 8e | LATIN CAPITAL LETTER I WITH CIRCUMFLEX |
U+00CF | Ï | I | c3 8f | LATIN CAPITAL LETTER I WITH DIAERESIS |
U+00D0 | Ð | Ð | c3 90 | LATIN CAPITAL LETTER ETH |
U+00D1 | Ñ | N | c3 91 | LATIN CAPITAL LETTER N WITH TILDE |
U+00D2 | Ò | O | c3 92 | LATIN CAPITAL LETTER O WITH GRAVE |
U+00D3 | Ó | O | c3 93 | LATIN CAPITAL LETTER O WITH ACUTE |
U+00D4 | Ô | O | c3 94 | LATIN CAPITAL LETTER O WITH CIRCUMFLEX |
U+00D5 | Õ | O | c3 95 | LATIN CAPITAL LETTER O WITH TILDE |
U+00D6 | Ö | O | c3 96 | LATIN CAPITAL LETTER O WITH DIAERESIS |
U+00D7 | × | × | c3 97 | MULTIPLICATION SIGN |
U+00D8 | Ø | O | c3 98 | LATIN CAPITAL LETTER O WITH STROKE |
U+00D9 | Ù | U | c3 99 | LATIN CAPITAL LETTER U WITH GRAVE |
U+00DA | Ú | U | c3 9a | LATIN CAPITAL LETTER U WITH ACUTE |
U+00DB | Û | U | c3 9b | LATIN CAPITAL LETTER U WITH CIRCUMFLEX |
U+00DC | Ü | U | c3 9c | LATIN CAPITAL LETTER U WITH DIAERESIS |
U+00DD | Ý | Y | c3 9d | LATIN CAPITAL LETTER Y WITH ACUTE |
U+00DE | Þ | Þ | c3 9e | LATIN CAPITAL LETTER THORN |
U+00DF | ß | ß | c3 9f | LATIN SMALL LETTER SHARP S |
U+00E0 | à | A | c3 a0 | LATIN SMALL LETTER A WITH GRAVE |
U+00E1 | á | A | c3 a1 | LATIN SMALL LETTER A WITH ACUTE |
U+00E2 | â | A | c3 a2 | LATIN SMALL LETTER A WITH CIRCUMFLEX |
U+00E3 | ã | A | c3 a3 | LATIN SMALL LETTER A WITH TILDE |
U+00E4 | ä | A | c3 a4 | LATIN SMALL LETTER A WITH DIAERESIS |
U+00E5 | å | A | c3 a5 | LATIN SMALL LETTER A WITH RING ABOVE |
U+00E6 | æ | A | c3 a6 | LATIN SMALL LETTER AE |
U+00E7 | ç | C | c3 a7 | LATIN SMALL LETTER C WITH CEDILLA |
U+00E8 | è | E | c3 a8 | LATIN SMALL LETTER E WITH GRAVE |
U+00E9 | é | E | c3 a9 | LATIN SMALL LETTER E WITH ACUTE |
U+00EA | ê | E | c3 aa | LATIN SMALL LETTER E WITH CIRCUMFLEX |
U+00EB | ë | E | c3 ab | LATIN SMALL LETTER E WITH DIAERESIS |
U+00EC | ì | I | c3 ac | LATIN SMALL LETTER I WITH GRAVE |
U+00ED | í | I | c3 ad | LATIN SMALL LETTER I WITH ACUTE |
U+00EE | î | I | c3 ae | LATIN SMALL LETTER I WITH CIRCUMFLEX |
U+00EF | ï | I | c3 af | LATIN SMALL LETTER I WITH DIAERESIS |
U+00F0 | ð | Ð | c3 b0 | LATIN SMALL LETTER ETH |
U+00F1 | ñ | N | c3 b1 | LATIN SMALL LETTER N WITH TILDE |
U+00F2 | ò | O | c3 b2 | LATIN SMALL LETTER O WITH GRAVE |
U+00F3 | ó | O | c3 b3 | LATIN SMALL LETTER O WITH ACUTE |
U+00F4 | ô | O | c3 b4 | LATIN SMALL LETTER O WITH CIRCUMFLEX |
U+00F5 | õ | O | c3 b5 | LATIN SMALL LETTER O WITH TILDE |
U+00F6 | ö | O | c3 b6 | LATIN SMALL LETTER O WITH DIAERESIS |
U+00F7 | ÷ | ÷ | c3 b7 | DIVISION SIGN |
U+00F8 | ø | O | c3 b8 | LATIN SMALL LETTER O WITH STROKE |
U+00F9 | ù | U | c3 b9 | LATIN SMALL LETTER U WITH GRAVE |
U+00FA | ú | U | c3 ba | LATIN SMALL LETTER U WITH ACUTE |
U+00FB | û | U | c3 bb | LATIN SMALL LETTER U WITH CIRCUMFLEX |
U+00FC | ü | U | c3 bc | LATIN SMALL LETTER U WITH DIAERESIS |
U+00FD | ý | Y | c3 bd | LATIN SMALL LETTER Y WITH ACUTE |
U+00FE | þ | Þ | c3 be | LATIN SMALL LETTER THORN |
U+00FF | ÿ | Ÿ | c3 bf | LATIN SMALL LETTER Y WITH DIAERESIS |
Additional Assistance
For additional assistance with inserting special characters into Banner forms:
- Email admin-computing@reed.edu