: I can not deal with databases that give me back a different value : from what I inserted. : : If I insert the string 'This is a string ' into a varchar field, : I want it back with the trailing space, not without it. If I : insert a 50 character string in a 25 character field, I want an : error, not a truncated string. If I define an integer field to be : NOT NULL, that does not mean I want any NULL I insert to be : silently converted to a 0.
Okay, that's fair. : Foremost, a database needs to be correct. The outcome of queries : in relational databases is mathematically exact. IMHO, that means : MySQL simply does not qualify as a relational database. And that's scary. Maybe I need to read about this a bit more. --BenD ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5