On Fri, Feb 08, 2008 at 11:06:40AM -0600, Christopher Singley wrote: > On Friday 08 February 2008 02:53:45 Oleg Broytmann wrote: > > If you find a problem - please publish more details. In case of PySQLite > > there is a way to map data to/from strings for any data; currently > > SQLObject uses this feature to map strings to/from unicode, and map > > date/time strings; it would be possible to add a mapping for Decimals. > > That sounds like a better way! Strings should be a fine way to store > fixed-point numbers of finite length. Are there any considerations that > might make this a bad idea?
If you are going to use (or allow to use) the DB in external non-python tools you have to document the mapping, and even the documents could not help in case of standard tools that don't know anything about the mapping. The mapping is a function of PySQLite2, not SQLite itself: http://initd.org/pub/software/pysqlite/doc/usage-guide.html#sqlite-and-python-types 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
