APSW Column affinity override not working?
Scott Chapman <[email protected]>
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
I have a table with a column type of NUMERIC (I'm building a shim layer to convert python types to some of the SQL types). When I insert a string value of '123.3231' into this column, it goes in as a REAL rather than an INTEGER. I read in the docs that a declared column type of NUMERIC should have a column affinity of REAL, and that I can override the column affinity by inserting a literal in single or double quotes. However when I insert a literal in single quotes it is getting stored (and subsequently retrieved) as a REAL, not a string. If I read the docs right, this is a bug. Please kill the bug or tell me how to make that override work! :) I can make the column type NUMERIC_TEXT and it works correctly but I don't want to use _TEXT in the column type (and if I'm reading the docs right, shouldn't have to.) APSW version 3.3.13r1 on Windows under Python 2.5. Please advise. Thanks! Scott