Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 10-18-2010, 09:52 PM   #1
LQ Newbie
Registered: Sep 2010
Posts: 3

Rep: Reputation: 0
description of openoffice base, table design, field types

I have searched around to no avail to find somewhere that describes what the field types are in table design, in OpenOffice Base (3.1). I would like to know the size of the fields, what defines them - are they 255 characters long, ect. a simple example of appropriate uses (for each one) would be a plus. I didn't expect this to be hard to find.

One (tutorial) post said the memo field saved 6GB! I can't believe that and I am sure the post wasn't a funny. I have only seen var-mixed and integer even mentioned. Surely someone knows? Help didn't help, the wiki glossed around it and the lovely tutorials that didn't just say "Use the Wizard" only gave examples of two types. I've used Access before and expected a simple highlight and hitting the F key would pop up the answer - but nope! I didn't even find a fatty-fat book at my local book store.... QUE let me down. I put this in newbie, because it is my first OpenOffice database.

Just the different text field types would be enough. These are different than in my Access 2000 book. I would also like to know if you limit the characters to say 25 for the text box, if the file size is actually any smaller or if in the data base it is saved the same as if it were 255?
Old 10-19-2010, 12:04 AM   #2
Senior Member
Registered: Jan 2003
Posts: 2,786

Rep: Reputation: 372Reputation: 372Reputation: 372Reputation: 372
You mean a page like this

-- first result on a Google search with these terms: openoffice base data types

Another page that might be useful (but too long for me to read through): here

I hope that's enough to get you going
Old 10-20-2010, 01:01 PM   #3
LQ Newbie
Registered: Sep 2010
Posts: 3

Original Poster
Rep: Reputation: 0

That is exactly what I wanted.
I was trying "Field types" and getting nothing. Data types... now why didn't I think of that? The power of proper keywords has been proven again.
Learning this again after 10 years of not using it is proving to be fun. Thanks for keeping me on track. Openoffice 3 Base seems to be quite close to Access 2000

Last edited by ekathy; 10-20-2010 at 02:31 PM.
Old 10-20-2010, 02:30 PM   #4
LQ Newbie
Registered: Sep 2010
Posts: 3

Original Poster
Rep: Reputation: 0
2nd link you suggested

I had read the second link and it was one of the things that led to my confusion.
It has the problem of many of the tutorials - the person writing it does not have a complete grasp of the subject.
For example, I quote:
"There is a text type field of fixed size. It's size is 2 gigabytes per record, so I'm not sure who would find it useful!

It is the "Memo" type, marked [longvarchar]."

If you look at the table on the first page you suggested - you find ALL the text fields have a MAX LENGTH of 2 GB. so although he did have the information "sort-of" correct, the way it was presented, made me wonder what the actual facts were. The truth is, the possible sizes are all the same and the memo doesn't necessarily (if I read the chart correctly) use up any more space than text (var char).

If I am wrong on this please correct me - I just wanted to mention it in this thread in case someone else is wondering.

I do appreciate the people who do the tutorials - they are wonderful and helpful. I just need to work a bit harder with my keywords to check on facts I have confusion about. The many unpaid hours of online support is unbelieveable - thanks everyone.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Overuse of flash, and other types of poor web-design Jeebizz General 22 03-07-2007 05:30 AM
Help with MySQL - how to design table? socceroos Programming 10 02-19-2007 10:29 PM
How do I Bulk Edit One Field in a db Table in phpMyAdmin?? ShuggsRR Linux - Newbie 1 10-23-2006 01:54 PM
caps sensitivity in mysql table/field name Swakoo Linux - General 0 11-14-2005 01:16 AM
How to insert same text in one field for 10,000 records table edhan Linux - Newbie 6 06-13-2005 03:48 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 06:37 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration