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

Appendix A. Data Type Mapping
A-2
MySQL
Datalogger
Data Type
MySQL
Data Type Notes
IEEE4 FLOAT
MySQL FLOAT data
type only stores 6
digits of precision. The
datalogger stores 7.
FP2 FLOAT
Long INT
UINT2
SMALLINT
UNSIGNED
String TEXT
Boolean BIT(1)
Bool8 BIT(1)
Nsec DATETIME
MySQL DATETIME
does not support
subsecond information.