Promotic
WikipediaLinkedInYoutubeTwitterFacebook

Data type in dBase

Data type Length Description
CHAR(precision)   string of fixed lenght, where n is the number of saved characters.
NUMERIC(precision,scale)   Number (range, accuracy)
FLOAT(precision,scale)   binary numbers with decimal separator, that is available in dBase IV and newer versions. The maximal number that can be written is the size of 20,18 (the size is defined the same way as for the Numeric data type).
DATE '0000-00-00' the date and format where the numbers are separated into days, months and years. The default date format is mm/dd/yy, for example 02/20/16 for the 20th of February 2016. The dates in DBF files can also be subtracted. The result of such operation will be the number of days between those days. The number of days can also be added to the date, resulting in a new date occuring after the defined number of days.
LOGICAL   data type that corresponds to the yes/no or true/false for each record in the file. This data type is 1 byte long and accepts the following characters: Y, y, N, n, T, t, F, f.
MEMO   data type that can be used for storing larger texts. In the record, the memo type array takes up 10 bytes, containing the information that there is a DBT (Data Base Text) existing and containing the array of separate records. The text limit is 64kB.
 
precision – (Range) is a number of digits to the left of the decimal separator
scale – (Accuracy) is the decimal accuracy, i.e. the number of digits to the right of the decimal eparator
 
Maximum values of precision and scale
dBase version precision,scale
dBASE II 16,14
dBASE III 19,15
dBASE III PLUS 19,15
dBASE IV 20,18
dBASE 5.0 20,18
 
See msdn.microsoft.com/en-us/library/windows/desktop/ms713987%28v=vs.85%29.aspx.
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice