Re: [sqlite] using lower function with utf8

2019-09-19 Thread x
Yes, I’m using v5 JcD. Thanks. From: sqlite-users on behalf of Jean-Christophe Deschamps Sent: Thursday, September 19, 2019 3:49:39 PM To: SQLite mailing list Subject: Re: [sqlite] using lower function with utf8 >I was messing about with this and tr

Re: [sqlite] using lower function with utf8

2019-09-19 Thread Jean-Christophe Deschamps
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

[sqlite] using lower function with utf8

2019-09-19 Thread x
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