Am 04.08.2006 um 19:23 schrieb Cory Nelson:
I was not talking about sorting in my post - I've had simple = index comparisons fail in UTF-8.
I'm pretty sure you can get the same kind of 'failure' when using UTF-16, e.g. when comparing decomposed against composed forms of unicode strings. Since sqlite only really does a 'binary' comparison, this may easily fail for non-ASCII strings.
Also, there's a prominent warning in the documentation about working with case-insensitive comparison (since it only does it right for ASCII characters). Maybe this is where some more complete unicode support is most sorely missing, but it's probably beyond sqlite's scope to do proper unicode-savvy case shifting...?
</jum>
