add support for MySQL way of storing date types (ability to always store NULL regardless of schema), fixing type precedence and detection, switching from re to str.startswith were appropriate (for speed).