[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.ca/> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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: 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] Running SQLite Test Suites
>./configure; make test > >I just ran it on Solaris, as shown above, and it appears to be working fine. >You will need a relatively recent version of TCL, however. 8.5 or 8.6. >From the REAME file: ... If the configure script does not work out for you, there is a generic makefile named "Makefile.linux-gcc" in the top directory of the source tree that you can copy and edit to suit your needs The reason "make test" was not working for us is because Makefile.linux-gcc does not contain the test targets. Is there a reason why the test targets 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
Is there an example extension you know that I could look at that does this? (i am a novice at SQLite) From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Pavel Ivanov [paiva...@gmail.com] Sent: March 1, 2012 8:52 AM 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 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 still set to the last time I set it, how do I go about > accomplishing this. Create a special table for that and store your last locale value in it. Then after reconnect read the locale value from this table. Pavel ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 still set to the last time I set it, how do I go about accomplishing this. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[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 Assistant | Seneca CDOT Phone: 416-491-5050 x3548 cdot.senecac.on.ca <http://cdot.senecac.on.ca/> ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
