I think you'll find your answers in the documentation: <https://sqlite.org/quirks.html> <https://sqlite.org/datatype3.html>