Jim Fulton wrote:
Christopher Petrilli wrote:
...
We make this decision based on the precision and scale of the column, NOT fo the returned value. Anything that has a scale of >0 is a float. If it's scale is 0, then if the precision is greater than 9, we move to long integers to store it.
Because we can use regular integers if the precision is less than 10.
If you need a string without the trailing 'L', then use the %d string format, as in '%d' % v.
Jim
P.S. Python 1.6 will not add the trailing 'L' character when converting longs to strings, except when the repr built-in function or operator is used. That will make this issue go away.
Thanks for the info. Makes things a bit easier. -- In flying I have learned that carelessness and overconfidence are usually far more dangerous than deliberately accepted risks. -- Wilbur Wright in a letter to his father, September 1900