search

dinedal / textql

Execute SQL against structured text like CSV or TSV
MIT License
9.06k stars 300 forks source link

Using NUMERIC instead of TEXT #45

Closed ivotron closed 6 years ago

ivotron commented 9 years ago

NUMERIC is the highest in sqlite's type affinity rules.

https://www.sqlite.org/datatype3.html

Putting text in columns of type NUMERIC means they'll be actually treated as TEXT.

Fixes #42

dinedal commented 6 years ago

Closing this as this is already done