# JDBC River decimal problem **URL:** \ **Category:** Elasticsearch\ **Created:** [July 29, 2014, 2:12pm UTC](https://discuss.elastic.co/t/jdbc-river-decimal-problem/18950 "2014-07-29T14:12:23Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Simon\_Madsen](https://avatars.discourse-cdn.com/v4/letter/s/b487fb/32.png) [@Simon\_Madsen](https://discuss.elastic.co/u/Simon_Madsen)\ **Post date:** [July 29, 2014, 2:12pm UTC](https://discuss.elastic.co/t/jdbc-river-decimal-problem/18950/1 "2014-07-29T14:12:23Z")
Hey everyone i've just implemented a River pulling data from a database, and it is working just fine, except one of my columns is a FLOAT(7,2) type, but when it is imported into elasticsearch, the decimalpoint is deleted Example: Fieldvalue: 999.99 ES-value: 99999 I know this isn't much information to go on, but have you heard of this problem before? Thanks in advance Simon -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/6c6f13c0-b0b1-4608-bb29-e8dea886b9ce%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/6c6f13c0-b0b1-4608-bb29-e8dea886b9ce%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [July 29, 2014, 2:40pm UTC](https://discuss.elastic.co/t/jdbc-river-decimal-problem/18950/2 "2014-07-29T14:40:22Z")
Parsing numbers depends on the locale. Can you check if setting the "locale" parameter of the JDBC river makes any difference? I admit this is poorly documented. Jörg On Tue, Jul 29, 2014 at 4:12 PM, Simon Madsen \< [simon.hammerholt.madsen@gmail.com](mailto:simon.hammerholt.madsen@gmail.com)\> wrote: > Hey everyone > > i've just implemented a River pulling data from a database, and it is > working just fine, except one of my columns is a FLOAT(7,2) type, but when > it is imported into elasticsearch, the decimalpoint is deleted > > Example: Fieldvalue: 999.99 ES-value: 99999 > > I know this isn't much information to go on, but have you heard of this > problem before? > > Thanks in advance > Simon > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/6c6f13c0-b0b1-4608-bb29-e8dea886b9ce%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/6c6f13c0-b0b1-4608-bb29-e8dea886b9ce%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/6c6f13c0-b0b1-4608-bb29-e8dea886b9ce%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/6c6f13c0-b0b1-4608-bb29-e8dea886b9ce%40googlegroups.com?utm_medium=email&utm_source=footer) > . > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoF%2Bb3OQ-Mf-o84BuqCEZh-dXxNn47xAuhgE9wZrKRWJBg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoF%2Bb3OQ-Mf-o84BuqCEZh-dXxNn47xAuhgE9wZrKRWJBg%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:12am UTC](https://discuss.elastic.co/t/jdbc-river-decimal-problem/18950/3 "2017-07-06T01:12:30Z")