# What is the maximum character length of "Field Name"?

What is the maximum character length of "Field Name" in Base please?

edit retag close merge delete

What a question. I have entered 100 characters and have no end. A field title should not be a novel. Maybe someone can give you the exact number of characters that are possible for a field label. What do you want to achieve?

( 2018-09-13 16:54:06 +0200 )edit

Thank you for the answer. I'm new to Base and the last database product I used in depth was Foxpro which had a 10 character limit for "field name". There were also field "labels", for which the character limit could be specified up to 256 characters. The difference in Foxpro was that the field name was what was seen internally by the program, the label was what was used on a form. I haven't gotten that far yet with the current database I'm building, but I'm hoping Base has a similar feature.

( 2018-09-14 11:55:49 +0200 )edit

You know that starting from LO version 6.1 a new internal database "Firebird" is used? Before that, the internal database was HSQLDB. You can also use other databases under Base.

( 2018-09-14 12:59:23 +0200 )edit

@ebot Unless you turn on Experimental features the default DB is still HSQLDB. Although Firebird can be used when turned on, there are still a number of issues to deal with.

( 2018-09-14 16:16:02 +0200 )edit

@Ratslinger Thanks for the hint. Firebird was just a general hint when someone joins Base. I had already done a test with the "Experimental Function", but I let it happen again. But someone who starts with base and internal DB now has a hard time in the transition phase.

( 2018-09-14 16:49:08 +0200 )edit

Sort by » oldest newest most voted

Hello,

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.

more