On 18 Aug 2010, at 7:26am, Doug Reeder wrote: > Does SQLite treat strings as sequences of opaque 16-bit values, except > for the wildcard operators for LIKE and GLOB? Does it care about > surrogate code points? Does it care about FDD0 to FDEF ?
The first: opaque. It doesn't understand anything about two-byte text, Unicode, or even FFFE/FEFF. LIKE and GLOB operate on a strictly ASCII basis, and behaviour with anything with the top bit set is unpredictable. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users