Data types

The following table contains the data types that TenUp accepts in the command line, spec tree, and table tree.

The data types below are accepted in the command line -i switch, the spec tree <type></type> metadata, and in the table tree <th type></th> metadata.

Note: If you are using a table tree, you must quote the type name because all XML attribute values must be quoted (such as <th type="i">). If you are using a spec tree, the type name should not be quoted because it appears as XML content (such as <type>i</type>). On the command line, either quotes or no quotes is acceptable.
Data type Type name Description
text text

a

1Btext

String values that contain uppercase and lowercase letters, numbers, spaces, and symbols

1Btext contains 1 byte of text.

integer int

i

1Bint

2Bint

4Bint

8Bint

Signed

Whole numbers between -2,147,483,646 and 2,147,483,646

You can also specify 1, 2, 4, or 8 byte integers.

float float

f

4Bfloat

8Bfloat

dec

64-bit floating-point values

You can also specify 4 or 8 byte floating-point values.

big integer bigint

j

Whole numbers between -9,223,372,036,854,775,806 and 9,223,372,036,854,775,806

date, time, and date+time YYYYMMDD

YYMMDD

MMDDYY

DDMMYY

MMDDYYYY

DDMMYYYY

YYYYMM

YYMM

MMYY

MMYYYY

HHMM

YYYYMMDDHHMMSS

Month, day, and year, as well as time and date+time formats. These month data types are "tolerant of decoration," which means that you can format a date with "decoration" such as slashes and colons; for example, 11/5/2017 or 09:57:03. In the case of YYYYMMDDHHMMSS, only the date portion is tolerant of decoration.