SQLite

  1. The SQLite database driver includes the SQLite library, except on systems where that library is commonly available, like Linux distributions, Mac OS X and mobile devices.
  2. Make sure the database client locale is properly defined. The SQLite library uses UTF-8. If the current character set (LANG/LC_ALL) is not UTF-8, like plain ASCII or UTF-8, the database driver will make appropriate character set conversions.
  3. You can make a connection test with the sqlite3 command line tool.