if you insert a non-numeric string like ‘wxyz’ into an INTEGER column, unlike other SQL databases, SQLite does not throw an error. Instead, SQLite stores the actual string value in the column
why :whyMelt:
wo this so fucked up
official doc ?
@cafou they say this is a feature and not a bug
Follow
+bonifartius 𒂼𒄄
@xarvos @cafou i never had problems with sqlite or it's behavior of storing type with the value instead of the table, but there is https://sqlite.org/stricttables.html now.
