: Try to cast MySQL decimal data type to string, i.e.
:
: CAST( IF(drt.discount IS NULL,'0',(drt.discount/100)) AS CHAR) as discount
: (or CAST AS TEXT)
...to clarify here, the values you are seeing are what happens when the DB
returns to DIH a value in a type it doesn't udnerstand -- in this c
Try to cast MySQL decimal data type to string, i.e.
CAST( IF(drt.discount IS NULL,'0',(drt.discount/100)) AS CHAR) as discount
(or CAST AS TEXT)
On Mon, Dec 19, 2011 at 1:24 PM, Niels Stevens wrote:
> Hey everybody,
>
> I'm having an issue importing Decimal numbers from my Mysql DB to Solr.
> Is