Ask Your Question

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

asked 2018-09-13 16:13:32 +0200

Machba gravatar image

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

edit retag flag offensive 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?

ebot gravatar imageebot ( 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.

Machba gravatar imageMachba ( 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.

ebot gravatar imageebot ( 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.

Ratslinger gravatar imageRatslinger ( 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.

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

1 Answer

Sort by » oldest newest most voted

answered 2018-09-13 17:49:00 +0200

Ratslinger gravatar image


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.

edit flag offensive delete link more


Thank you for the answer. I'm new to using Base and I just wanted to know for future reference as I have experience with other database products which also truncated field names. Currently, my max length is 17 characters. I just didn't want to run into problems if the database required a long field name.

Machba gravatar imageMachba ( 2018-09-14 11:46:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-13 16:13:32 +0200

Seen: 37 times

Last updated: Sep 13 '18