COVID-19 Response and Reopening

Invalid Characters

The @ symbol should not be used in any field with the exception of email address.

The following characters have special meaning to Oracle (the database system) and may cause errors. They should not be used.

  • $ dollar sign
  • % percent sign
  • * asterisk
  • "" double quotation marks
  • á  é  í  ó  ú  ñ  ü accent marks
  • ; semi-colon
  • : colon
  • || double pipe
  • / forward slash
  • \ back slash
  • [ ] brackets
  • ( ) parentheses
  • { } braces

Additionally, when used in Naming Conventions (example: Course Titles), special characters including commas, single quotes and periods create reporting inconsistencies either in internal reporting systems or when reporting externally in state or federal reporting.

All data throughout the Banner system should be entered using standard capitalization rules. Capitalize the first letter of all proper nouns. Example: Ronald A McDonald

Examples of problems that special characters in Banner name fields have caused when data is extracted to other systems:

  • Employee PERS uploads to the State have failed because of accent marks on first names.
  • The Library Patron extract file has failed to upload when a bad record breaks the extract proccess.
  • Names in Canvas have been illegible because special characters are not translated correctly.

Last Updated: 12.07.21 - cmills

Page Owner: All Departments