[erlang-questions] odbc unsigned values

Jed McCaleb <>
Thu Jan 8 16:33:28 CET 2009


it is saying it is of type: sql_integer
Thanks,
Jed.

On Thu, Jan 8, 2009 at 3:16 AM, Ingela Anderton Andin <
> wrote:

> 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.
> >
> >
>
> _______________________________________________
> erlang-questions mailing list
> 
> http://www.erlang.org/mailman/listinfo/erlang-questions
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20090108/74d81956/attachment.html>


More information about the erlang-questions mailing list