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/

Reply via email to