Alexander Foken schrieb:
On 18.05.2009 15:42, Tod A. Sandman wrote:
On Sat, May 16, 2009 at 06:07:05PM +0200, Alexander Foken wrote:
[snip]
I tried using "TOCHAR" verbatim (I'm ultra weak in sql), but I got a
mysql syntax error (I'm using mysql-4.1.22).
Yes, TOCHAR is what I've remembered
On 18.05.2009 15:42, Tod A. Sandman wrote:
On Sat, May 16, 2009 at 06:07:05PM +0200, Alexander Foken wrote:
Perl silently converts Integers to Floats to prevent integer overflow.
Unless you have a perl with 64 Bit integers (see perl -V), this may bite
you here: You get the usual floating poi
Original Message
Subject:Re: selecting a bigint
Date: Mon, 18 May 2009 08:42:56 -0500
From: Tod A. Sandman
To: Alexander Foken
References: <20090515201703.gi6...@rb3.is.rice.edu>
<4a0ee4a9.8030...@foken.de>
On Sat, May 16, 2009 at 06:0
Perl silently converts Integers to Floats to prevent integer overflow.
Unless you have a perl with 64 Bit integers (see perl -V), this may bite
you here: You get the usual floating point rounding issues. If you
explicitly convert the bigint to a string already in the database, so
that perl read
I'm trying to use DBI and DBD::mysql with perl-5.8.8 on a 64bit Redhat
host:
Linux host 2.6.9-67.0.20.ELsmp #1 SMP Wed Jun 18 12:35:02 EDT 2008 x86_64
x86_64 x86_64 GNU/Linux
I need to do table lookups based on a column of type bigint. I don't
generate or manipulate the bigint value myself -
