Campbell Scientific LNDB LoggerNet Database Software - Manual (Page 43)

Appendix A. Data Type Mapping
Datalogger data types are mapped into database data types differently
depending on the type of database as described below.
SQL Server Compact
Datalogger Data
Type
SQL Server Compact
Data Type Notes
IEEE4 REAL
FP2 REAL
Long INT
UINT2 INT
String NVARCHAR(2048)
Boolean BIT
Bool8 BIT
Nsec DATETIME Resolution is 3ms
SQL Server
Datalogger
Data Type
SQL Server
Data Type Notes
IEEE4 REAL
FP2 REAL
Long INT
UINT2 INT
String NVARCHAR(MAX)
Boolean BIT
Bool8 BIT
Nsec
DATETIME or
DATETIME2
Record Timestamp is
DateTime2
(resolution is 100ns).
All others are
DateTime (resolution
is 3ms).
A-1