Microsoft Access (JDBC) Writer: User Attributes

This format supports the following field types.

autonumber

Used to generate an automatically incremented numeric counter. Only one autonumber field is allowed in each table.

byte

Represents 8-bit unsigned integers.

currency

Represents monetary data values up to 15 digits of whole dollars and 4 decimal places.

datetime

Represents date and time data January 1, 0100 to December 31, 9999 with an accuracy of 3.33 milliseconds. Note: FME accurately represents data only after the date October 15, 1582.

See Standard FME Date/Time Format.

decimal

Represents fixed precision and scale numeric data from -10^28-1 through 10^28-1.

double

Represents 64-bit floating precision numbers.

integer

Represents 16-bit signed integers.

long

Represents 32-bit signed integers.

memo

Represents character data up to a length of 65,536 characters.

oleobject

Represents binary large objects. The data must be specially formatted to be read correctly in Microsoft Access.

replicationid

Represents GUIDs. As such, it must be set up like a valid GUID. For example: {B85E62C3-DC56-40C0-852A-49F759AC68FB}

single

Represents 32-bit floating precision numbers.

text

Represents character data up to a length of 255 characters.

yesno

Represents a logical field with a value of True or False. Nulls are automatically changed to False in yesno fields.