On 11/26/06, Allen Gilliland <[EMAIL PROTECTED]> wrote:
Well, we should see how other databases handle the same situation,
because technically there is no way we could support storing the path in
the database at a length of 255 if we continue to allow 255 chars for
node names and infinite hierarchy depth.
I am fine with changing the column to a varchar(255), but that will mean
the users could potentially run into problems with creating hierarchies
that are too deep.
Problem is that Derby (and I suspect other databases as well) do not
support comparisons on CLOB fields. We can't use a big VARCHAR because
MySQL 4 does support VARCHAR's longer than 255. So, the fix I
committed was to allow MySQL to continue to use TEXT and everybody
else uses VARCHAR(1000).
- Dave
