MariaDB/SkySQL (MySQL-compatible) Spatial User Attributes

Readers: For information on the parameters in this dialog that are common to all readers, see:

Writers: For information on the parameters in this dialog that are common to all writers, see:

User attributes for this format are defined below.

Name

The name of the field to be written.

Valid values for field name include any character string devoid of SQL-offensive characters and less than 63 characters in length.

Type

The type of a column in a table. The valid values for the field type are listed below:

  • bigint
  • blob
  • char
  • date
  • datetime
  • decimal(width, precision)
  • double(width, precision)
  • float(width, precision)
  • int
  • longblob
  • longtext
  • mediumblob
  • mediumint
  • mediumtext
  • smallint
  • text
  • time
  • timestamp
  • tinyblob
  • tinyint
  • tinytext
  • varchar(width)
  • year - Corresponds to MySQL data type year(4).
  • year(width) - Corresponds to MySQL data type year(2). Although this attribute is no longer supported as of MySQL 5.7, to preserve backwards compatibility, FME will continue to support it.

Note: The writer will expect the associated value of the year and year(width) attributes to be in the format of yyyymmdd, and the reader will also return in the same format. The accepted input is within the ranges of: 1901 to 2155 for year; and 00 to 99 for year(width) (which corresponds to the 4-digit years 2000 to 2069, and 1970 to 1999).

Index

The type of index to create for the column.

The valid values for the index type are listed below:

  • BTree: B-Tree-based geometry index (default attribute index)
  • Hash: Hash-based geometry index
  • PrimaryKey: Any primary key or identity attribute