SQLite Forum

null character sorts greater than 0x7f and less than 0x80
Login
I don't disagree, but at the same time, since SQLite already has code for UTF-8,  
it would be useful to have a is_utf8() built-in function for those that want to opt-in  
to strict UTF-8 enforcement using a `CHECK` constraint.