[Zope] MYSQL Problem

[Andy Dustman]

On Sun, 28 Jan 2001, Jens Grewen wrote:

> I installed 
> 
> mySQL-3.23.32
> mySQLdb 0.3.1
> ZmySQLDA 2.0.4
> 
> When I change to mediumint (database field description) I get the
> expected 233.
> 
> How can I fix this.

You just did. :) If a mediumint is big enough for you, use that. As Ron
points out, INTEGER (particularly UNSIGNED) can overflow in Python, so
they need to be returned as Python long integers. Python adds the L when
doing str(), but Python 2.0+ does not do this (only on repr()).

-- 
Andy Dustman         PGP: 0xC72F3F1D
    @       .net     http://dustman.net/andy
"Normally with carbonara you use eggs, but I used lobster brains instead."
    -- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster Battle