The following table lists all the internal data types that are defined in Data Exchange, and used while implementing a user-defined function:
Table B.1.
| Internal Data Types | Description | Supported/Not Supported (for user-defined function return value) |
Boolean | An unsigned numeric value that can be 0, 1, or a null reference. | Supported |
Byte | An 8-bit unsigned integer. | Supported |
DateTime | Displays date and time data ranging from January 1, 1753 to December 31, 9999, of an accuracy of 3.33 milliseconds. | Supported |
Decimal | A fixed precision and scale numeric value between -10E38-1 and 10E38 -1. | Supported |
Double | A double-precision floating point value ranging from -1.79769E+308 to 1.79769E+308. | Supported |
Float | A floating point number within the range of -1.79E+308 to 1.79E+308. | Not Supported |
Guid | A global unique identifier. | Not Supported |
Int64 | A 64-bit signed integer. | Supported |
Timestamp | An array of bytes that automatically generates binary numbers. | Not Supported |
Xml | An XML structure value. | Not Supported |
Date | Displays date data ranging from January 1, 1 AD to December 31 9999 AD. | Supported |
Time | Displays time data based on a 24-hour clock, ranging from 00:00:00 to 23:59:59.9999999. | Supported |
DateTimeOffset | Displays date and time data with time zone awareness. | Not Supported |
UnicodeString | A fixed or unfixed length double-byte string value. | Supported |
AsciiString | A fixed or unfixed length single-byte string value. | Supported |
ByteArray | A fixed or unfixed length of binary value. | Not Supported |
TimeSpan | A time-interval measured as a positive or negative number of days, hours, minutes, seconds, and fractions of a second. | Supported |
Object | Any data type object. | Not Supported |
DigitString | Used for numeric values that cannot be expressed in C#. | Supported |
KanjiString | Used for DMSII/RDMS Unicode character types. | Supported |
FloatingPointDigitString | Used for floating point number values that cannot be expressed in C#. | Not Supported |