Yes, I’m using v5 JcD. Thanks.
________________________________ From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of Jean-Christophe Deschamps <j...@antichoc.net> Sent: Thursday, September 19, 2019 3:49:39 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] using lower function with utf8 >I was messing about with this and tried the following in sqlite expert >professional > >select unicode(lower(char(256))); > >I was quite surprised when it responded with the correct result 257. > >Looking at the sqlite3.c code I can’t see anything that suggests >sqlite would handle lower() for non-ascii characters so I tried the >same thing in a c programme and it came back with the expected wrong >answer 256. > >Am I right in saying 256 is the expected sqlite answer? > >Can anyone suggest why it works in the former? Expert v5 (I expect that's what you use) includes Unicode support and overrides sqlite3.dll lower(). JcD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
