Re: [SQLObject] Decimals in sqlite

[Oleg B. <ph...@ph...>]

On Wed, Feb 13, 2008 at 05:40:44PM -0600, Christopher Singley wrote:
> If you're always doing ORDER BY a single column with a fixed size/precision, 
> then the case above (for size=13, precision=9) would actually be
> "0009.110000000" and "2112.123456789"; I think all strings of that format 
> should sort the same way as the numbers they represent.

   Yes, but think about (size=5, precision=5). SQLObject doesn't do
a quantization, and SQLite will store "2112.123456789" - it is just
a string - but what about the padding?..

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.