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_varbinary(width) Variable-length binary data. width defines the maximum size, in bytes.
fme_binarybuffer Unbounded binary data.
fme_char(width) Fixed-length string data. width defines the string length.
fme_varchar(width) Variable-length string data. width defines the maximum length.
fme_buffer Unbounded character string.
fme_xml XML data.
fme_json JSON data.
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_date

Defines a date. For supported date formats, see Standard FME Date and Time 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_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_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_int64 Integer data that occupies 8 bytes.
fme_uint64 Unsigned integer data that occupies 8 bytes.
fme_int32 Integer data that occupies 4 bytes.
fme_uint32 Unsigned integer data that occupies 4 bytes.
fme_int16 Integer data that occupies 2 bytes.
fme_uint16 Unsigned integer data that occupies 2 bytes.
fme_int8 Integer data that occupies 1 byte.
fme_uint8 Unsigned integer data that occupies 1 byte.
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.