On 23 May 2019, at 3:55am, Keith Medcalf <kmedc...@dessus.com> wrote:
> Technically, COLLATE only works on TEXT. Most people declare their own types > as binary blobs and the programmer has to keep track of what is in there and > how to work with it. So it would seem that rather than define a function which turns a value of my type into a BLOB, it would be better to create one which turns it into some sort of normalised text form. Then I can create whatever COLLATEs I need to do my specialised sorting and handling. IP addresses are easy: convert to the form aaa.bbb.ccc.ddd where each of the four parts is always three digits long. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
