Really! Ya learn something new every day.
On Wed, Sep 17, 2014 at 10:48 AM, Chris Hostetter <hossman_luc...@fucit.org> wrote: > > : second, and assuming your problem is really that you're looking at the > : _display_, you should get back exactly what you put in so I'm guessing > > Not quite ... With the numeric types, the numeric value is both indexed > and stored so that there is no search/sort inconsistency between 1.1, > 1.10, 001.1 etc... those are all the number "1.1" and are treated as such. > > > if you have an input string of that you want preserved verbatim, then you > need to use a string type. It doesn't matter if those strings *look* > like numbers or not, if you consider "27.50" to be different from "27.5" > then those aren't numbers, they are strings. > > > -Hoss > http://www.lucidworks.com/