Hi Sorry by my bad English.
Why SQLite dropped the 8859 or single byte support for text? Is there any technical reason? Is there any ready simple solution to use case insensitive collation on SQLite to work with non-English (Latin) characters? I don't need and I don't want a full ICU implementation after all I'm using utf8 only because I can't count with a better option. I don't need the full and correct implementation, a "just works" implementation for trivial use is enough. The assumption that the application has the proper comparison function is valid only when the application works with utf8. That's not my case exactly because the full correct implementation is heavy and not valuable for the requirements. It's ironic that utf8 (the universal encoding) support turned SQLite into an English centric database by default. Best regards Antonio Maniero _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users