On 9 Feb 2014, at 6:05pm, Constantine Yannakopoulos <alfasud...@gmail.com> wrote:
> - You are assuming that 'z' is the higher order character that can appear > in a value. This is not the case; for instance greek characters have higher > order than 'z'. This can be fixed (only for latin/greek) by using the > highest order greek character 'ώ' (accented omega) instead of 'z'; but I > would prefer a very high-order non-printable one instead. By all means replace the 'zzzzzzzzzzzz' I typed with a string of 200 accented lower-case omegas. Or with (char)0x7F or some other equivalent. Since (if I remember my Greek) it's impossible for a word to contain three omegas in a row, I doubt you'll come across any occurrences of it from anyone who is using your program realistically. Hmm. I assume that some internal part of SQLite would actually be putting this string through your collation function. It would presumably happen automatically as part of what SQLite does. I know it's a hack. But it's an elegant efficient hack that takes advantage of the things SQLite does well. As long as that's the only way you were using LIKE. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
