Difference between VARCHAR and TEXT in MySQL

TL;DR TEXT fixed max size of 65535 characters (you cannot limit the max size) takes 2 + c bytes of disk space, where c is the length of the stored string. cannot be (fully) part of an index. One would need to specify a prefix length. VARCHAR(M) variable max size of M characters M needs to be between 1 and 65535 takes … Read more

Don’t understand why UnboundLocalError occurs (closure) [duplicate]

Python doesn’t have variable declarations, so it has to figure out the scope of variables itself. It does so by a simple rule: If there is an assignment to a variable inside a function, that variable is considered local.[1] Thus, the line implicitly makes counter local to increment(). Trying to execute this line, though, will try to read the value of … Read more