2 ms·
Couldn't your issue be addressed by writing an application-defined function [0] called something like "utf8_is_valid()" and invoking it in the CHECK constraint?
by skissane 5y ago
Couldn't your issue be addressed by writing an application-defined function [0] called something like "utf8_is_valid()" and invoking it in the CHECK constraint?
(Probably should tag the custom function SQLITE_DETERMINISTIC|SQLITE_INNOCUOUS to make sure you can use it in a CHECK constraint.)
[0] https://www.sqlite.org/appfunc.html https://www.sqlite.org/appfunc.html