Nones are returned in place of the empty string on a TEXT NOT NULL column

[tlevine]

The schema is something like this

CREATE TABLE debt (                                                                                                                         
  [City] TEXT NOT NULL,
);

And here's the problem.

In [7]: dt.execute("select City from debt where City = ''")
Out[7]: 
[OrderedDict([(u'City', None)]),
 OrderedDict([(u'City', None)]),
 OrderedDict([(u'City', None)])]

[pwaller]

I'm closing old issues so that we can pluck signal from the noise. Please reopen if you encounter this or believe it is important.