<div dir="ltr"><div>Should be: <br>TDS_Version = 7.1<br></div><div>in that config.<br><br></div>in that case it returns <br>{selected,[[]],[{"1"}]} <br></div><div class="gmail_extra"><br><div class="gmail_quote">On 12 March 2018 at 20:24, Michael Uvarov <span dir="ltr"><<a href="mailto:freeakk@gmail.com" target="_blank">freeakk@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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]              <wbr>                              <wbr>                         <br>    Driver = /usr/lib/x86_64-linux-gnu/<wbr>odbc/libtdsodbc.so            <wbr>                <br>    Setup = /usr/lib/x86_64-linux-gnu/<wbr>odbc/libtdsS.so               <wbr>                 <br>    Server = 127.0.0.1                     <wbr>                              <wbr>            <br>    Port = 1433                          <wbr>                              <wbr>              <br>    Database = ejabberd                      <wbr>                              <wbr>                                        <wbr>   <br>    Charset = UTF-8                         <wbr>                              <wbr>           <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:                               <wbr>                       <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>
</blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">С уважением,<br>Уваров Михаил.<br>Best regards,<br>Uvarov Michael</div>
</div>