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
