FME Data Types

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

Type

Description

Range (if applicable)

fme_data_type

binary(width)

Binary stores fixed-length binary data.

Width defines the size, in bytes.

 

fme_binary(width)

binarybuffer

Binary buffer stores unbounded (of any size) binary data.

 

fme_binarybuffer

buffer

Buffer stores unbounded (of any length) character strings.

 

 

fme_buffer

char(width)

Character stores fixed-length string data.

Width defines the maximum number of characters that can be stored.

No padding is required for strings shorter than this width - they may be of any length up to the defined width.

 

fme_char(width)

date

Date store dates as character strings with the format YYYYMMDD.

See Standard FME Date/Time Format.

 

fme_date

datetime

Date/Time stores dates as character strings with the format [Date][Time], as in:

YYYYMMDDHHMMSS.FFF

The [Time] component may be formatted with or without fractional seconds, and with or without a UTC offset.

See Standard FME Date/Time Format.

 

fme_datetime

int16

 

Integer, 16-bit stores signed integers in 2 bytes (16 bits) of space.

-32768 to 32767

fme_int16

int32

Integer, 32-bit stores signed integers in 4 bytes (32 bits) of space.

-2147483648 to 2147483647

fme_int32

int64

Integer, 64-bit stores signed integers in 8 bytes (64 bits) of space.

-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

fme_int64

int8

Integer, 8-bit stores signed integers in 1 byte (8 bits) of space.

-128 to 127

fme_int8

json

JSON stores unbounded strings formatted in JSON (JavaScript Object Notation).

 

fme_json

logical

Logical stores TRUE/FALSE data, which may be any of:

  • An integer value of 1 (true) or 0 (false)

  • Any string that begins with "t" or "y" (true), or "f" or "n" (false), or NULL.

 

fme_boolean

number(width, precision)

Number stores single and double precision floating point values.

Width is the total number of characters allocated to the field, including the decimal point.

Precision controls the precision of the data and is the number of digits to the right of the decimal.

 

fme_decimal(width,decimal)

real32

Real32 stores floating-point numeric data that occupies 4 bytes (32 bits) in standard IEEE floating-point format.

There is no ability to specify the precision and width of the field.

3.4E +/- 38 (7 digits)

fme_real32

real64

Real64 stores floating-point numeric data that occupies 8 bytes (64 bits) in standard IEEE floating-point format.

There is no ability to specify the precision and width of the field.

1.7E +/- 308 (15 digits)

fme_real64

time

Time store times as character strings with the basic format

YYYYMMDDHHMMSS.FFF

They may be formatted with or without fractional seconds, and with or without a UTC offset.

See Standard FME Date/Time Format.

 

fme_time

uint16

Unsigned integer, 16-bit stores integers greater than or equal to 0 in 2 bytes (16 bits) of space.

0 to 65535

fme_uint16

uint32

Unsigned integer, 32-bit stores integers greater than or equal to 0 in 4 bytes (32 bits) of space.

0 to 4294967295

fme_uint32

uint64

Unsigned integer, 64-bit stores integers greater than or equal to 0 in 8 bytes (64 bits) of space.

0 to 18,446,744,073,709,551,616

fme_uint64

uint8

Unsigned integer, 16-bit stores integers greater than or equal to 0 in 1 byte (8 bits) of space.

0 to 255

fme_uint8

varbinary(width)

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

 

fme_varbinary(width)

varchar(width)

Variable character fields store variable length strings.

Width controls the maximum number of characters that can be stored by the field. These are often used to optimize storage.

 

fme_varchar(width)

xml

XML stores unbounded strings formatted as XML (Extensible Markup Language).

 

fme_xml