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