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 that field names 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.