We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Why can't I create field names more than 10 characters long in Base? [closed]

asked 2012-03-11 12:43:36 +0200

v_2e gravatar image

updated 2015-10-21 15:50:23 +0200

Alex Kemp gravatar image


Today I tried the LibreOffice Base for the first time. I want to create a database for my home library. So I used a database Wizard to create a database and then added a table to it. But the problem currently is that I cannot assign a name with more than 10 characters long to any field. Moreover, if I use the Latin characters, I can type 10 symbols, but if I use Cyrillic characters, I can only have a name of 5 characters length. I suspect, this is somehow connected to UTF-8 (2 bytes per symbol).

In any case, is there a way I can give the table fields name more than 10 characters long?


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-21 15:50:32.050685


I couldn't reproduce this problem, which would otherwise be a bug. I was able to create field names with more than 10 characters and populate a test database. Which LibreOffice version are you using?

MagicFab gravatar imageMagicFab ( 2012-03-11 15:25:59 +0200 )edit

I use LibreOffice- from Gentoo GNU/Linux repository. The "About" dialog says:LibreOffice 3.5.0rc3 ID сборки: 350m1(Build:13). Thank you!

v_2e gravatar imagev_2e ( 2012-03-11 17:12:50 +0200 )edit

Hi @v_2e, Have you had a chance to try the latest 3.6 or 4.0-beta builds? It's possible that the limitations you were seeing last year have been removed. If you have time, please test and let us know. Thanks!

qubit gravatar imagequbit ( 2013-01-22 04:19:30 +0200 )edit

Hello @qubit! I tried LO today, but the problem is still there. Only 10 charachers-long name is allowed.

v_2e gravatar imagev_2e ( 2013-02-10 20:14:22 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-02-10 21:39:47 +0200

qubit gravatar image

Per @v_2e:

Hello @qubit! I tried LO today, but the problem is still there. Only 10 charachers-long name is allowed.

Very bizarre. Okay, please file a bug report and explain your situation in detail including what works and what doesn't (that bit about Cyrillic, etc...). If this isn't an outright bug, then you can turn it into an Enhancement Request.

Good luck!

edit flag offensive delete link more

answered 2012-03-26 00:53:03 +0200

AnnB gravatar image

I'm using LibreOffice Build ID: 350m1(Build:102) on Ubuntu 11.10 and I can't reproduce your problem either - could it be some limit or defect inherent in your language pack?

This is kind of off-topic, but here goes: Have you looked at any Linux collection manager apps (gcstar and tellico)? I was also going to do a database for my books, but it was SO intimidating. With gcstar, I enter the ISBN number and it collects info from an online database (author, title, publisher, etc.). I have put in 600+ books in a just few days.

edit flag offensive delete link more


Hello! I tried with LibreOffice Build ID: 350m1(Build:202) and got the very same limitation - 10 characters for field names in tables. As for your suggestion about other dedicated software, I'll try some of them. Thak you.

v_2e gravatar imagev_2e ( 2012-04-12 16:36:26 +0200 )edit

Question Tools


Asked: 2012-03-11 12:43:36 +0200

Seen: 1,246 times

Last updated: Feb 10 '13