> 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:
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
> 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
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
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:
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
>
>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
-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
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
9 matches
Mail list logo