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?
[Solved] Database field width unalterable
[Solved] Database field width unalterable
Last edited by Hagar Delest on Sun May 28, 2017 9:04 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OpenOffice 4.1.1
Windows XP Sp3
Windows XP Sp3
Re: Database field width unalterable
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.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Database field width unalterable
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
Windows XP Sp3
-
- Posts: 1
- Joined: Wed Mar 08, 2023 6:40 pm
Re: [Solved] Database field width unalterable
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