SQLite Forum

Sqlite3 Trigger
Login
> what is the point of varchar when it doesnt enforce the specified length without the check?

sqlite (note the LITE part) supports various standardized data type names for syntactic compatibility with non-lite SQL systems, but it's up to the application to enforce any such requirements.