SQLite Forum

null character sorts greater than 0x7f and less than 0x80
Login
> One could write a user defined function, say "valid_utf8", that verifies a field is truly UTF-8 and use it in check constraints

The sequence C0 80 is perfectly valid UTF-8 encoding.  
That you may not like that fact is immaterial.