[sqlite] icu_load_collation: How do I load a case-insensitive collation?

Hi there, How do I load a case-insensitive collation using the icu_load_collation method that is provided by the ICU extension. Regards, Grace Batumbya Research Assistant | Seneca CDOT Phone: 416-491-5050 x3548 cdot.senecac.on.ca<http://cdot.senecac.on

Re: [sqlite] Running SQLite Test Suites

> The "test" target is in the file "main.mk" which is "include"-ed by the very > last line of Makefile.linux-gcc. Thanks Richard. That clears up things. -- Grace Batumbya Research Assistant | Seneca CDOT Phone: 41

Re: [sqlite] Running SQLite Test Suites

ets are not included in the generic makefile? Thanks. -- Grace Batumbya Research Assistant | Seneca CDOT Phone: 416-491-5050 x3548 cdot.senecac.on.ca ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Set Locale for upper() and lower() using a pragma variable

To: General Discussion of SQLite Database Subject: Re: [sqlite] Set Locale for upper() and lower() using a pragma variable On Thu, Mar 1, 2012 at 8:50 AM, Grace Batumbya <grace.batum...@senecacollege.ca> wrote: >>You can simply register your >>own lower/upper with one argument that

[sqlite] Set Locale for upper() and lower() using a pragma variable

>You can simply register your >own lower/upper with one argument that looks wherever you want to know >what locale to use. The part of registering a function to override lower/upper I think I understand. But if I wanted to persist the locale, so that even if I disconnect and reconnect it is

[sqlite] Procedure (Conditional statement) workaround

Hey guys, Since SQLite does not support stored procedures, what are some workarounds that are used to accomplish things like executing a statement based on a conditional. For example. IF value OF column IN tableX == 'foo' DO statement 1 ELSE statement 2 Thanks, -- *Grace Batumbya* Research