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.
Home | Site Contents | Documentation | NexusDB Manual V4 | Management Tools | The Enterprise Manager | Creating and Restructuring Tables