I looked this back up to see what the exact issues where that Jochem had with mysql again. I can live with the trailing space issue. I dont care about null becoming zero. I am a little concerned about truncation... this could matter a lot. What exactly is the limit of simultaneous transactions with Access? That could also matter a lot. To give you a better idea, it is supposed to be a patient management system for a single doctor. But I would want to design it is such a way that if the doctor oh, merges his practice with several other doctors and becomes a very busy clinic, then we don't have to throw the whole thing out and start over, or massage the data to import it into something else.
Thanks for anyone who gives some thought to this for me. Dana On Sat, 07 Jun 2003 15:12:23 -0400, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Ben Doom wrote: >> What do you prefer? >> >> We use MS SQL 2K here, but are looking into using MySQL for intranet >> rollouts, so I'm curious as to your opinion. > > I prefer almost everything over MySQL. I can deal with weird syntax. I > can deal with performance issues. I can deal with murky installations. I > can deal with bad documentation. I can deal with limits on the number of > simultaneous connections. > > 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. > > 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. > > Jochem > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5