I implemented a DECIMAL type and ended up making a small patch to Sqlite to stop it changing the type to numeric. As I recall it was very simple.
Aladdin Lampé wrote: > Hi! > I've just created my own "DECIMAL" set of user functions using the IBM > decNumber library. > I would like to assign my decimal columns the type "DECIMAL([precision])", > but they are given the NUMERIC affinity, and numbers are converted when > inserted in TEXT format... That's exactly what I'm trying to prevent because > this would mess the DECIMAL results! > I've thought to name my decimal type "DECIMAL_TEXT([precision])" in order to > force the TEXT affinity (no conversion) but I'm not very pleased with this > solution. > Does somebody have a better one? Could somebody point me where to patch > SQLite in order to avoid that? > Thank you, > Aladdin > > _________________________________________________________________ > Découvrez les profils Messenger de vos amis ! > http://home.services.spaces.live.com/ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users