Page 1 of 1

mysql version conflict

PostPosted: 18. July 2007 01:56
by genarator
Hi guys, somehow mysql 5 is not suporting a database with more than 255 fields, but apparently mysql 4 does, so can you tell me wich version of xampp comes with it?, I really wouldn't like to try configure mysql 4 with the last version of xampp, better off if it comes configured already....

PostPosted: 18. July 2007 02:30
by Wiedmann
somehow mysql 5 is not suporting a database with more than 255 fields,

That's wrong:
- With MyISAM you can have 3398 columns.
- With InnoDB you can have 1000 columns.

Maybe your column definition is to long (>64K).

(BTW: You mean columns, not fields?)

Uh?

PostPosted: 19. July 2007 18:16
by genarator
columns and fields are the same, they differ from rows...
But I didn't consider the storage engines