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