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/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
