What's the consensus here? Currently, the database creation scripts setup MySQL to continue to use TEXT for the category and folder path fields and and everybody else uses VARCHAR(1000). Not ideal, but it works.
Should I change that and force all databases to use VARCHAR(255) for the path fields? That will work on all databases (MySQL 4 is the limiting factor). Either way, we'll have to add logic to prevent users from creating category hierarchies that will not fit in the path field. - Dave On 11/27/06, Elias Torres <[EMAIL PROTECTED]> wrote:
Dave wrote: > On 11/27/06, Allen Gilliland <[EMAIL PROTECTED]> wrote: ...[snip]... > Yeah, I don't like one-offs either. My preference is to use the > shortest varchar within reason. Unfortunately, thanks to MySQL 4.X, > that 255. Fortunately, as you point out, that's well within reason > considering our current category usage. > > - Dave > I guess that as long as we stick to varchars we can also leave that up to the installer to decide the needs of their site as a last resource. -Elias
