Forum OpenACS Development: Is object_type supposed to be a varchar2(1000) in Oracle?

Collapse
1: Is object_type supposed to be a varchar2(1000) in Oracle?
Posted by Barry Books on 03/01/04 01:11 PM
I recall object_type being a varchar2(100) in Oracle but I was looking at my acs 5.0 database and it's a varchar2(1000). Is this a typo or was this change intentional. 1000 characters seems pretty large for an indexed field in a table as large as acs_objects.
Collapse
2: Re: Is object_type supposed to be a varchar2(1000) in Oracle? (response to 1)
Posted by Don Baccus on 03/01/04 07:03 PM
Does it use fixed-length records in the index?  That's the only reason it would matter.

If so then a shorter limit would seem more reasonable, yes.

We want it the same in both versions so folks don't get suddenly surprised when they try their code on "the other" database.