On 12/5/2016 3:43 PM, Don V Nielsen wrote:
Igor, I'm not sure if you gain anything from"length(lower(name))". Just "length(name)" would suffice.
I'm guarding against various Unicode weirdnesses that could cause string length to change on case transformation. While SQLite only folds ASCII letters by default, it could be compiled with full ICU collation support.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
