SQLite Forum

Sqlite3 Trigger
Login
"varchar" is the same as the type "Humpback Character Giraffes" in that it contains the string "char" that indicates the affinity is text.  Otherwise it is just an arbitrary string of characters.

<https://sqlite.org/datatype3.html>

varchar(n) may have other implementation specific meanings in other database management systems.

** Edited to fix a typo of the " mark