[Solved] Database field width unalterable

Discuss the database features
Post Reply
User avatar
ubiquity
Posts: 20
Joined: Fri Aug 24, 2012 3:23 am
Location: Tasmania, Australia

[Solved] Database field width unalterable

Post by ubiquity »

I'm using O-O 4.1.3 on Windows 10
Attempting to build a number of tables but finding that length of Integer fields, regardless of whether they are primary key or not, cannot be altered.They are fixed at 10
Is this a persistent bug as I see it reported elsewhere without resolution and for other operating systems?
Last edited by Hagar Delest on Sun May 28, 2017 9:04 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 4.1.1
Windows XP Sp3
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Database field width unalterable

Post by Villeroy »

A 32-bit integer reaches from -2,147,483,647 to +2,147,483,648. That is no more and no less than 10 decimals.
Depending on the type of database, there may be a DECIMAL type where you can specify the length and the decimals. DECIMAL(12,0) is a 12 digit number with no decimals after the point.

For non-arithmetic numbers (zip codes, part numbers, phone numbers) you may choose a textual type like CHAR(12) and edit it through a formatted field on a form. Formatted fields can be limited to digits only.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
ubiquity
Posts: 20
Joined: Fri Aug 24, 2012 3:23 am
Location: Tasmania, Australia

Re: Database field width unalterable

Post by ubiquity »

Thanks! I realised my conceptual error some time about 2am this morning - I had been looking to restrict "input" not bit size.
OpenOffice 4.1.1
Windows XP Sp3
RedBaron11
Posts: 1
Joined: Wed Mar 08, 2023 6:40 pm

Re: [Solved] Database field width unalterable

Post by RedBaron11 »

I just started a new database and am attempting to add "Description", but all can add is "Descriptio", seemingly limiting me to 10 characters. I have chosen "text" as my field type. What's the cure?
Open Office 4.1.14 on Windows10 with 64 bit PC
Post Reply