Oddegamra
-
2014-04-13
- status: open --> closed-fixed
The data types in the library's SQL schema are mostly defined as "string". Turns out that the proper data type should be "text", not "string". "string" isn't actually a recognized type, so columns end up with an integer affinity, meaning that all strings that are inserted which look like numbers get converted to numbers, and subsequently are returned as numbers.
Steps to reproduce>
1. Create collection with a name of "1".
2. Library view causes exception.