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

2012-03-02 Thread Pavel Ivanov
> I have created my own function  which uses a global variable for the default > locale. (see attached) I guess I received your attachment because you sent this email to me directly but generally this list doesn't allow attachments - you should include your code into email. And about your code:

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

2012-03-02 Thread Grace Simon Batumbya
That's a wrong approach. First, you don't need to modify functions in SQLite code, you need to create your own. Your function will convert using locale saved in some variable in your application. I have created my own function which uses a global variable for the default locale. (see

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

2012-03-01 Thread Pavel Ivanov
> Given that there exists a table db_locale [CREATE TABLE db_locale (locale > text)], > what lines of code would be used to query that table from inside this > function? That's a wrong approach. First, you don't need to modify functions in SQLite code, you need to create your own. Your function

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

2012-03-01 Thread Grace Simon Batumbya
I found the function that I would need to modify (see below). |static void icuCaseFunc16(sqlite3_context *p, int nArg, sqlite3_value **apArg){ const UChar *zInput; UChar *zOutput; int nInput; int nOutput; UErrorCode status = U_ZERO_ERROR; const char

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

2012-03-01 Thread Grace Batumbya
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:

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

2012-03-01 Thread Pavel Ivanov
On Thu, Mar 1, 2012 at 8:50 AM, Grace Batumbya 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 >

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

2012-03-01 Thread Grace Batumbya
>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

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

2012-02-29 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 29/02/12 12:23, Carl Desautels wrote: > I would like to be able to run one statement that sets the locale for > upper() and lower() If you register a function with the same name and number of arguments as a builtin one, then yours will take

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

2012-02-29 Thread Carl Desautels
From the ICU documentation, ( http://www.sqlite.org/src/artifact?ci=trunk=ext/icu/README.txt) To access ICU "language specific" case mapping, upper() or lower() should be invoked with two arguments.[...] lower('I', 'tr_tr') -> 'ı' (small dotless i) With an ICU enabled build of SQLite, I