Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version


Field names, as well as all identifiers, depend upon the database you are using. If you are using the default database for Base, that is HSQLDB Embedded v1.8. Later versions show this size to be 128 characters. Anything beyond that is truncated.

But using something near this size can present other problems. If later on you decide to move to a different database such as MySQL or PostgreSQL, you now will get truncation to 63 (PostgreSQL) or 64 (MySQL) characters. Early versions of Oracle were 30 characters with newer versions at 128. Other databases may be different.

It is best to keep the length low.