Re: ENUM and large strings

2001-05-19 Thread David Christopher Asher
> > > In order to save space in our database, we designed our tables to use > > > enumerated datatypes. For one column, we have about 2,800 > > > different values, > > > each of which is about 30-40 text characters long. Now, all the MySQL > > > documentation I have read states that the limit fo

RE: ENUM and large strings

2001-05-18 Thread Daevid Vincent
> > In order to save space in our database, we designed our tables to use > > enumerated datatypes. For one column, we have about 2,800 > > different values, > > each of which is about 30-40 text characters long. Now, all the MySQL > > documentation I have read states that the limit for the num

RE: ENUM and large strings

2001-05-18 Thread Chris Bolt
Perhaps in your case it would be better to use another table and do a join? > Hi! > > In order to save space in our database, we designed our tables to use > enumerated datatypes. For one column, we have about 2,800 > different values, > each of which is about 30-40 text characters long. Now,