C# and Sqlite field length

Question

I have made a table in SQLite and choosed varchar(30) for one Field but it seems as i actually can save much longer strings, is this normal? Can anyone explain this to me?

Answer 1

Yes, it's normal, and explained in the documentation:

Note that numeric arguments in parentheses that following the type name (ex: "VARCHAR(255)") are ignored by SQLite - SQLite does not impose any length restrictions (other than the large global SQLITE_MAX_LENGTH limit) on the length of strings, BLOBs or numeric values.

(Note that before seeing this question, I had no idea about this. It's always worth checking the documentation first.)