Restrictions on the Use of Datatypes

SourcePro DB : DB Access Module for Microsoft SQL Server User’s Guide : Technical Information : Datatypes : Restrictions on the Use of Datatypes

Microsoft SQL Server places restrictions on the use of certain datatypes. Where possible, the DB Interface Module is flexible about datatypes. However, there are some situations where conversions are not possible. In these cases your application must be aware of the contexts in which certain datatypes can be used. Table 3 outlines the restrictions associated with each DB Interface Module type.

Table 3 – Restrictions on the use of DB Interface Module datatypes
RWDBValue::ValueType	Restrictions
Blob	No restrictions
Char UnsignedChar	No restrictions
Date	No restrictions
DateTime	The Microsoft SQL Server datatype datetime supports dates ranging from January 1, 1753 through December 31, 9999, 23:59:59.997 and rounds to increments of .000, .003, or .007 seconds.
TimeTuple	Microsoft SQL Server rounds to increments of .000, .003, or .007 seconds
TimeTupleOffset	Not supported
Decimal	No restrictions
Double	No restrictions
Duration	Not supported by Microsoft SQL Server
Float	No restrictions
Int UnsignedInt	No restrictions
Long UnsignedLong	No restrictions
LongLong UnsignedLongLong	No restrictions
MBString	Not supported by Microsoft SQL Server
Tiny UnsignedTiny	No restrictions
Short UnsignedShort	No restrictions
WString	No restrictions. Refer to Internationalization for more information
String UString	No restrictions
LongDouble	No restrictions