[erlang-questions] odbc unsigned values

Ingela Anderton Andin ingela@REDACTED
Thu Jan 8 09:16:56 CET 2009


Hi!

What erlang odbc will return depends on which SQL-DATATYPE that the 
driver you use claims it to be.
You can use odbc:describe_table/[2,3] to find out what type will be 
returned. When we know that maybe
we can derive if the erlang-odbc port program needs an update or not.

Regards Ingela Erlang/OTP - Ericsson
 
> Hi,I'm trying to port my erlang app to linux. It works fine on windows but I'm
> having trouble with odbc on linux. Basically anytime I do something like
> this:
>
> SQL="Select BigInt from Table",
> odbc:sql_query(DBRef, SQL).
>
> If BigInt is over 2147483647 it will just return 2147483647.
>
> in mysql BigInt is of type: int(10) unsigned
> it works fine from isql
> I'm using odbc-2.10.2
>
> Is this a known problem? Any ideas how to fix?
> Thanks for any help,
> Jed.
>
>   




More information about the erlang-questions mailing list