Identifiers constraints

[dmorgoon]

What are restrictions (prohibited characters, length, etc) for identifiers (column and table names)?

[sanikolaev]

In RT mode, table name:

• Can contain a - z, 0 - 9 and _.
• Can't start with 0 - 9.
• The length is restricted by the file system: if Manticore can't create a file, it can't create the table.
• The name is case insensitive.
• Lowercased at creation.

Column name:

• Can contain a - z, 0 - 9 and _.
• Can't start with 0 - 9.
• Lowercased at creation.
• Length: not sure about the max, 64KB works.

[dmorgoon]

Thanks)