[libreoffice-users] Numerical terms used in Base

It's been way too many years since I did commercial programming on
databases and I've forgotten some of the terms (formats) for numerical
data.  I'm trying to create a simple database of local
facilities/doctors/stores with Base using the wizards. The formats that
are giving me trouble are:

Text[VARCHAR]    - a variable number of type CHAR?
Text(fix)[CHAR]  - does that mean a fixed number of CHAR?
Integer[INTEGER] \
Numeric[NUMERIC]  > How do these differ?
Decimal{DECIMAL] /

I looked in LibreOffice help but couldn't find the definitions.  Some
help would be appreciated.

For instance, which format is used for a telephone number?
(1.800.123.4567)?

Thanks, Tom

-- 
“What we do for ourselves dies with us. What we do for others and the
world remains and is immortal.”  Albert Pine
--
Tom Taylor - retired penguin
AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2
openSUSE 12.1x86_64    openSUSE 12.2x86_64
KDE 4.7.2, FF 7.0      KDE 4.8.4, FF 13.0
claws-mail 3.8.0
registered linux user 263467
linxt-At-comcast-DoT-net

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted