From the ICU documentation, ( http://www.sqlite.org/src/artifact?ci=trunk&filename=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 would like to be able to run one statement that sets the locale for upper() and lower() so that they default to that locale instead of ASCII. At the moment I am thinking of adding a "pragma" variable, which would then be used by "icuCaseFunc16" as the default locale, how do I go about adding a "pragma" variable? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users