Re: Text Case

Gerhard Häring <[email protected]> Sat, 29 Sep 2007 18:55:48 +0200

Newsgroups	gmane.comp.python.db.pysqlite.user
Message-ID	<[email protected]>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Rich Shepard wrote:
>    Is pysqlite case sensitive? If a user inadvertently enters a string in
> both lower case and capitalized (on two table rows), will a search for the
> string find both instances?

Default for LIKE is a case-insensitive search. The search behaviour can be
controlled via

PRAGMA case_sensitive_like = 0 | 1;

- -- Gerhard
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFG/oOUdIO4ozGCH14RAsSHAJ9PVJ4U3mDKlmCysOoQIX2YF3qOpwCeNZHA
IhJDNqVuAk+WFazLVgpWKeQ=
=/6XE
-----END PGP SIGNATURE-----