Supported Datatypes for Conversion Transformations - 23.1

spectrum-inline

Product type
Software
Portfolio
Enrich
Integrate
Locate
Verify
Product family
Spectrum
Product
Spectrum > Quality > Addressing
Spectrum > Dataflow Designer
Spectrum > Spectrum Platform
Spectrum > Quality > Context Graph
Spectrum > Quality > Spectrum Quality
Spectrum > Data Integration
Spectrum > Spatial > Spectrum Spatial
Spectrum > Discovery
Spectrum > Geocoding > Enterprise Tax
Spectrum > GeoEnrichment
Spectrum > Web Services
Version
23.1
Language
English
Product name
Precisely Spectrum
Title
spectrum-inline
First publish date
2007
ft:lastEdition
2023-06-02
ft:lastPublication
2023-06-02T09:54:39.526000

supports the datatypes mentioned in the table below while applying conversion transformations.

Table 1. Supported Datatypes for Conversion Transformations
Type Description
String or Varchar Variable length character string with a maximum length of 4000
Varbinary Variable length binary string with a nominal maximum length of 8192
Char A single Unicode character
Boolean A single bit, or Boolean, with two possible values
Byte or Tinyint Numeric, integral type, signed 8-bit
Short or Smallint Numeric, integral type, signed 16-bit
Integer or Serial Numeric, integral type, signed 32-bit.

The serial type also implies not null and has an auto-incrementing value that starts at 1. Serial types are not automatically UNIQUE.

Long or Bigint Numeric, integral type, signed 64-bit
Biginteger Numeric, integral type, arbitrary precision of up to 1000 digits
Float or Real Numeric, floating point type, 32-bit IEEE 754 floating-point numbers
Double Numeric, floating point type, 64-bit IEEE 754 floating-point numbers
Bigdecimal or Decimal Numeric, floating point type, arbitrary precision of up to 1000 digits
Date Datetime, representing a single day (year, month, day)
Time Datetime, representing a single time (hours, minutes, seconds, milliseconds)
Timestamp Datetime, representing a single date and time (year, month, day, hours, minutes, seconds, milliseconds, nanoseconds)