Supported Datatypes for Conversion Transformations - 23.1

spectrum-inline

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

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)