Supported Datatypes for Data Transfer

RAP supports the following datatypes for data transfer.

Supported datatypes for data transfer
RAPCache datatype	RAPStore datatype	Comment
[unsigned] `bigint`	[unsigned] `bigint`
[unsigned] `int`	[unsigned] `int`
[unsigned] `smallint`	[unsigned] `smallint`
`tinyint`	`tinyint`
`bit`	`bit`
`decimal (p,s)`	`decimal (p,s)`	Limited to precision 38. Precision must be the same on RAPCache and RAPStore.
`numeric (p,s)`	`numeric (p,s)`	Limited to precision 38. Precision must be the same on RAPCache and RAPStore.
`float`	`double`
`double`	`double`
`real`	`real`
`money`	`money`
`smallmoney`	`money`
`[var]binary(n)`	`[var]binary(n)`	Limited by RAPCache page size.
`[var]char(n)`	`[var]char(n)`	Limited by RAPCache page size.
`unichar(n)`	`binary(n)`	Limited by RAPCache page size.
`univarchar(n)`	`varbinary(n)`	Limited by RAPCache page size.
`date`	`date`
`time`	`time`
`smalldatetime`	`smalldatetime`, `datetime`	RAPCache type accurate to 1 minute.
`datetime`	`datetime`	RAPCache type accurate to 1/300th seconds.
`bigtime`	`time`	RAPCache type accurate to 1 microsecond.
`bigdatetime`	`datetime`	RAPCache type accurate to 1 microsecond.
`timestamp`	`varbinary(8)`

Note:

If a message contains an empty string, the empty string is stored as NULL in the RAPCache database and is stored as an empty string in the RAPStore database.