Windows Code Page 1252

MySQL tables used in LNDB 1.1 and LNDB 1.0 did not use Unicode/UTF-8 for displaying extended (non-English) characters. They used Windows Code Page 1252 (CP1252), which is nearly identical to ISO 8859-1, and which is sometimes called ANSI or Extended ASCII. CP1252 is shown here for reference:

To store characters that are not shown above (not a part of CP1252) with Campbell Scientific products, it is necessary to use UTF-8 Unicode encoding.

LNDB 1.1 and 1.0 systems that used MySQL usually encoded database tables as Latin1. Latin1 is 100% compatible with the CP1252 characters shown above. If your ongoing use of LNDB 1.2 and later does not require any more characters than those shown above, you may continue using the Latin1 table encoding that was created by LNDB 1.0 and/or 1.1. In that case, no migration of the table encoding and data is necessary. LoggerNet 4.2 or later and LNDB 1.2 or later can be installed and will work properly with existing Latin1 tables (CP1252) just as they did with earlier versions of LNDB and LoggerNet. This will not require any migration steps other than standard upgrade installations.