<div dir="ltr"><div><div><div><div>Hi,<br><br></div>I am using MSSQL with unixodbc on Ubuntu (unixodbc + tdsodbc packets).<br><br></div>My odbc.ini is:<br><br></div><br><div>[mongoose-mssql]                                                                     <br>    Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so                            <br>    Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so                                <br>    Server = 127.0.0.1                                                               <br>    Port = 1433                                                                      <br>    Database = ejabberd                                                                                               <br>    Charset = UTF-8                                                                  <br>    TDS Version = 8.0 <br><br><br>So, the query<br>odbc:sql_query(Conn, "select cast(1 as bigint)").<br></div><div>returns floats:                                                      <br></div><div>{selected,[[]],[{1.0}]} <br><br></div><div>instead of:<br>{selected,[[]],[{1}]} <br></div><br></div>Is there any way to change this behaviour?<br></div>