Re: [sqlite] ESCAPE and version dependent documentation

2006-07-13 Thread drh
Lukas Kahwe Smith <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > >> I am working on integrating pattern character escaping into PEAR::MDB2. > >> I am using PHP's ext/sqlite which only supports SQLite version 2 > >> (version 3 is supported only through pecl::pdo_sqlite). > >> > >> Is it

Re: [sqlite] ESCAPE and version dependent documentation

2006-07-13 Thread Lukas Kahwe Smith
[EMAIL PROTECTED] wrote: I am working on integrating pattern character escaping into PEAR::MDB2. I am using PHP's ext/sqlite which only supports SQLite version 2 (version 3 is supported only through pecl::pdo_sqlite). Is it possible to have literal % and _ in LIKE expressions in version 2? Sinc

Re: [sqlite] ESCAPE and version dependent documentation

2006-07-13 Thread drh
Lukas Kahwe Smith <[EMAIL PROTECTED]> wrote: > Hi, > > I am working on integrating pattern character escaping into PEAR::MDB2. > I am using PHP's ext/sqlite which only supports SQLite version 2 > (version 3 is supported only through pecl::pdo_sqlite). > > Is it possible to have literal % and _ in