CHAPTER 6 – SQLite – Character Encoding

SQLite has support for two character sets: ISO- 8859-1, which is the default and used for most western-European languages, and UTF-8. To enable UTF-8 mode, you need to tell the PHP ./configure com- mand to do so. The switch to use SQLite's UTF-8 mode is --enable-sqlite-utf8. This option only affects sorting results.