That depends if the value of the table column called "1" is 1 or not ...
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Stephen Chrzanowski >Sent: Monday, 4 December, 2017 12:01 >To: SQLite mailing list >Subject: Re: [sqlite] Why Unicode is difficult > >... as in how 1 != "1"? > >On Mon, Dec 4, 2017 at 11:07 AM, Igor Korot <ikoro...@gmail.com> >wrote: > >> Hi, >> >> On Mon, Dec 4, 2017 at 7:42 AM, Jay Kreibich <j...@kreibi.ch> wrote: >> > >> > >> > Next, we can talk about how dates and times are simple and >> straight-forward. >> >> And then the number representation... >> >> Thank you. >> >> > >> > -j >> > >> > >> > >> >> On Dec 4, 2017, at 7:08 AM, Simon Slavin <slav...@bigfraud.org> >wrote: >> >> >> >> Every so often someone asks on this list for Unicode to be >handled >> properly. I did it myself. Then other people have to explain how >hard >> this is. So here’s an article which, after introductory material, >> discusses the hard questions in Unicode: >> >> >> >> <https://norasandler.com/2017/11/02/Around-the-with- >Unicode.html> >> >> >> >> Are two strings the same? >> >> How long is a string? >> >> How do you sort things in alphabetical order? >> >> >> >> The first and third questions are requirements for implementing >COLLATE >> in SQLite. And the fact that the second question is a difficult >one >> emphasises that one shouldn’t take Unicode as simple. >> >> >> >> Simon. >> >> _______________________________________________ >> >> 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 >> _______________________________________________ >> 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
