On Tue, Nov 17, 2009 at 02:01:55PM -0500, Igor Tandetnik wrote: > This would mean that the result of the hypothetical flip() function > would be locale-dependent. E.g. in Spanish Traditional sort, a > combination 'ch' sorts as if it were a single letter between 'c' and > 'd', forming a single sort element (a so-called contraction). So > should 'a ch b' reverse to 'b ch a' under Spanish Traditional sort, > and to 'b hc a' otherwise? Would you pass a desired locale as a > parameter to flip(), in order to achieve that?
This is no longer true, either of 'ch' nor 'll'. The principle you state is correct, of course, but really, this is a collation problem, and affects SQLite3 apps regardless of "flip()". The collation is per-column, and the run-time should make functions aware of the collation (if any) of a column when an argument. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users