freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Problem with bigint queries?

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Problem with bigint queries?
Date: Fri, 2 Feb 2007 18:38:12 -0500

Martin Fandel wrote:
> Numer is shown in php+freetds: 2.6082000696729E+18
> Numer is shown in MS Query Analyzer: 2604016427929174238

Just a guess: maybe PHP converts bigint to double?

> Does someone know a solution?

Convert the number to a varchar in your query.

HTH.

--jkl

[freetds] Problem with bigint queries?, Martin Fandel, 02/02/2007
- Re: [freetds] Problem with bigint queries?, James K. Lowden, 02/02/2007