Skip to main content
Cartegraph Campus

Special Characters Usage

Special characters are often prohibited or require special handling.

Structure Manager

Recordset and Library Names

  • May contain numeric characters.
  • May contain spaces or an underscore between words.
  • These special characters are not allowed: ( ) [ ] { }

New Field Names

  • May contain numeric characters.
  • Must not include special characters, spaces, hyphens, ( ) [ ] { } $ % or #.
  • For GIS integration, Esri recommends field names should not contain special characters, such as spaces, hyphens, parentheses, brackets, commas, or characters such as /, $, %, ?, and #. 

ID Fields

  • Must not contain spaces between words.
  • Must not start with a numeric character.

Column Names

  • May contain numeric characters.
  • Must not include special characters, spaces, hyphens, ( ) [ ] { } $ % or #.
  • Must not start with a numeric character.

System Uses

Unique ID

These special characters not allowed in ID fields:

  • Right parenthesis            )
  • Quotation mark              “
  • Comma                             ,
  • Forward slash                  /

SQL Syntax

For fields with spaces or special characters (+, -, *, etc.) in the same name, or those that start with a number, the entire field name must be enclosed within [ ] to distinguish the field from other token types such as numbers and operators. For example, ["PO #" ].

Layer Names

Special characters are allowed.

  • Was this article helpful?