FME Data Types

FME supports the following data types internally. FME uses these data types when Mapping Attributes from Reader to Writer.

FME Data Type Description

fme_binary(width)

Fixed-length binary data. width defines the size, in bytes.

fme_binarybuffer

Unbounded binary data.

fme_boolean

An integer data type that can take an integer value of 1 (true) or 0 (false), or any string that begins with "t" or "y" (true), or "f" or "n" (false), or NULL.

fme_buffer

Unbounded character string.

fme_char(width)

Fixed-length string data. width defines the string length.

fme_date

Defines a date. For supported date formats, see Standard FME Date and Time Format.

fme_datetime

Defines a date that is combined with a time of day with fractional seconds, and is based on a 24-hour clock. For supported date and time formats, see Standard FME Date and Time Format.

fme_decimal(width,decimal)

Fixed-width and fixed-decimal numbers. width is the maximum total number of decimal digits, both to the left and to the right of the decimal point. decimal is the number of decimal digits to the right of the decimal point. This number is subtracted from width to determine the maximum number of digits to the left of the decimal point.

fme_int8

Integer data that occupies 1 byte.

fme_int16

Integer data that occupies 2 bytes.

fme_int32

Integer data that occupies 4 bytes.

fme_int64

Integer data that occupies 8 bytes.

fme_json

JSON data.

fme_real32

Floating-point numeric data that occupies 4 bytes in standard IEEE floating-point format.

fme_real64

Floating-point numeric data that occupies 8 bytes in standard IEEE floating-point format.

fme_time

Defines a time of day. The time is without time zone awareness and is based on a 24-hour clock. For supported time formats, see Standard FME Date and Time Format.

fme_uint8

Unsigned integer data that occupies 1 byte.

fme_uint16

Unsigned integer data that occupies 2 bytes.

fme_uint32

Unsigned integer data that occupies 4 bytes.

fme_uint64

Unsigned integer data that occupies 8 bytes.

fme_varbinary(width)

Variable-length binary data. width defines the maximum size, in bytes.

fme_varchar(width)

Variable-length string data. width defines the maximum length.

fme_xml

XML data.