My personal favorite - the inability to store an empty string, instead converting it to NULL leading to null-checks in code even though the value is known to be

My personal favorite - the inability to store an empty string, instead converting it to NULL leading to null-checks in code even though the value is known to be non-null when inserted.