NexusDB V2 only allows code page neutral ANSI characters in identifiers (table names, field names, ...), that is characters having the same ordinal value regardless of a code page. The following table shows the valid characters that can be used in regular identifiers:
Character |
Code |
Symbol |
Exclamation mark |
#33 |
! |
Pound sign |
#35 |
# |
Dollar sign |
#36 |
$ |
Percent |
#37 |
% |
Ampersand |
#38 |
& |
Left parenthesis |
#40 |
( |
Right parenthesis |
#41 |
) |
Plus sign |
#43 |
+ |
Minus sign |
#45 |
- |
Digit |
#48..#57 |
0..9 |
At sign |
#64 |
@ |
Upper case letter |
#65..#90 |
A..Z |
Left bracket |
#91 |
[ |
Right bracket |
#93 |
] |
Circumflex |
#94 |
^ |
Underscore |
#95 |
_ |
Lower case letter |
#97..#122 |
a..z |
Left brace |
#123 |
{ |
Right brace |
#125 |
} |
Tilde |
#126 |
~ |
• | A regular identifier is an unquoted string of characters. |
♦ | Regular identifiers cannot contain spaces. |
♦ | Regular identifiers cannot begin with a decimal digit. |
♦ | Regular identifiers are case-insensitive. |
♦ | The maximum length of regular identifiers is 128 characters. |