Skip to main content
Cartegraph Campus

Special Characters Usage

You must have administrator rights to access this feature.

This feature may not be available in every package. Not sure if you have this feature or you want to learn more about it? Send us a message at support@cartegraph.com

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?