On Wed, Feb 13, 2008 at 11:59:22PM -0600, Christopher Singley wrote:
> How does the data get marshalled by SQLObject and/or sqlite?
See sqlobject/converters.py.
> The
> size/precision constraints aren't really enforced by sqlite, are they?
In current situation SQLite converts them to float, what we are going
to fix.
> Does
> SQLObject police this?
No.
> Anyway, if we require that SQLObject work with legacy databases unmanaged by
> SQLObject, then I doubt that padding will make ORDER BY work right, in
> general.
>
> But if you ask me, having ORDER BY broken is better than having object types
> broken and potential inaccuracies in data that needs guaranteed accuracy.
I have a solution - a second type of DecimalCol - named DecimalStringCol,
may be - to allow the user to choose which implementation (s)he wants - the
current one (ok for most DB except SQLite) or strings-based.
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
