Converting Langstack data types to MS-SQL data types

Special care is needed when mapping types between Langstack and MS-SQL as it may cause data loss or overflow if the two types are not accurately compatible, or in cases where one of the mapped data types can contain a larger value than the mapped to data type can handle.

In case the transfer of the data causes an overflow, the default values will be transferred between MS-SQL and Langstack.

In case of mapping of approximate numeric types between Langstack and MS-SQL i.e. float and real data types, the mapped values may not have the exact accuracy.

Example

In case of conversion of the Langstack numeric data type to the MS-SQL smallmoney data type, the Langstack numeric field could contain a larger value than MS-SQL smallmoney data type can handle. In this case, it will overflow and the value will be reset to zero ‘0’.