Alternatively, you can
convert SQLite 2.X databases to a version 3 format by executing the following command: sqlite2
original.db .dump | sqlite3 new.db. Note that you??™ll need both the version 2 and version 3
interfaces to execute this command. Also, your interface names might not include the 2 or the 3; I??™ve
only done so to clarify which interface should be referenced where.
CHAPTER 22 ?– SQLITE 571
PHP??™s SQLite Library
The SQLite functions introduced in this section are quite similar to those found in the
other PHP-supported database libraries such as Oracle or MySQL. In fact, for many of
the functions, the name is the only real differentiating factor. Therefore, if you have
experience using any relational database, picking up SQLite should be a snap. Even if
you??™re entirely new to the concept, don??™t worry; you??™ll likely find that these functions
are quite easy to use.
sqlite.assoc_case = 0 | 1 | 2
Scope: PHP_INI_ALL; Default value: 0
One PHP configuration directive is pertinent to SQLite: sqlite.assoc_case, which
determines the case used for retrieved column names. While SQLite is case insensitive
when it comes to dealing with column names, various other database servers attempt
to standardize name formats by always returning them in uppercase letters. This
dichotomy can be problematic when porting an application to SQLite because the
column names used in the application may be standardized in uppercase to account
for the database server??™s tendencies.
Pages:
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655