Re: mysql install on OS X

2002-11-27 Thread christophe barbe
I use the binary from : http://www.entropy.ch/software/macosx/ Christophe On Wed, Nov 27, 2002 at 12:35:45PM -0800, Chris Herold wrote: i'm trying to install MySQL 3.23.53 on OS X. It seemed pretty easy as i followed the directions on the devshed website, but when i to make (for the

CHAR vs. VARCHAR

2002-10-08 Thread christophe barbe
After reading the mysql documentation, I am not sure to get correctly the pros and cons of the VARCHAR type. My understanding is that it is useful when a text field has a length that may vary a lot. For example I am thinking using it for a description field where users will put nothing or a

Re: CHAR vs. VARCHAR

2002-10-08 Thread Christophe Barbe
byte to store an empty comment. Christophe christophe barbe wrote: What are the disadvantages of using VARCHAR instead of CHAR. Is it going to be considerably slower? It really depends on your table, but if you find it slower, break down into multiple tables: create table

Re: CHAR vs. VARCHAR

2002-10-08 Thread christophe barbe
Is it then correct that VARCHAR(255) and TINYTEXT are strictly equivalent? If no, where is the difference? Thanks, Christophe NOTE: I understand now the sql,query stuff. Strange idea. -- Christophe Barbé [EMAIL PROTECTED] GnuPG FingerPrint: E0F6 FADF 2A5C F072 6AF8 F67A 8F45 2F1E D72C B41E