Hello, My perception of the InnoDB vs BDB question is that although the BDB is very impressive and long standing, it does not get the same level of attention that InnoDB seems to get from the good folks at MySQL AB. If I am not mistaken, BDB does not yet offer foreign key support.
I have chosen InnoDB instead of BDB and have not been disappointed so far. A signed interger is one that can accept both positive and negative values. Because storing the sign of a number uses one bit, and unsigned interger can hold a larger positve value than an unsigned integer. For example, given a 16 bit interger, the maximum value for an unsigned is 2^16, and 2^15 for the signed version. Regards, Michael --- Wouter van Vliet <[EMAIL PROTECTED]> wrote: > Heey There Folks, > > Well, I hope that this message gets through > finallly. First I got it back > from the deamon because I had send it in html > format, then because of I was > suspected from spamming this list. Only for not > having used the words query > or sql once ... well, I have now so it should come > through ;) hihi > > I just discovered the power of transactions in > databases and was wondering, > which table type is better; BdB or InnoDB ? and if > one is better than the > other, why is it? Does BdB also support referential > ingegrity as InnoDB > does? > > Also, I was wondering what SIGNED or UNSIGNED > integer are .. really don't > have a clue about it :D > > That were some questions I was wondering about .. > > Greetz, > Wouter > > ---------- > Alle door mij verzonden email is careware. Dit houdt > in dat het alleen > herlezen en bewaard mag worden als je goed omgaat > met al het leven op aarde > en daar buiten. Als je het hier niet mee eens bent > dien je mijn mailtje > binnen 24 uur terug te sturen, met opgaaf van reden > van onenigheid. > > All email sent by me is careware. This means that it > can only be reread and > kept if you are good for all the life here on earth > and beyond. If you don't > agree to these terms, you should return this email > in no more than 24 hours > stating the reason of disagreement. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php