Additional constraints

In addition to the above naming conventions and data types, the following rules apply when mapping LN data to SQL Server data:

• Because the binary sort order is selected during the installation, the SQL Server treats object names with case sensitivity.
• All columns created by the LN MSQL driver have the NOT NULL constraint. LN does not currently support NULL values in the data.
• The date range supported by the LN application virtual machine is not the same as the range for the SQL Server (the SQL Server is more restrictive). Therefore, some LN dates are not valid when stored with the LN MSQL driver. The LN date 0 is mapped to the earliest possible date in the SQL Server (01-Jan-1753). The earliest possible LN date is then 02-Jan-1753 and the latest is 31-Dec-9999.