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,

ENUM and large strings

2001-05-18 Thread David Christopher Asher
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, all the MySQL documentation I have read states that the limit for the number of ENUM keys