[rt-devel] 4k ought to be enough for anyone (schema.Oracle Support in RT)

seph seph at directionless.org
Tue Mar 18 02:36:24 EST 2003


> Currently all of these columns are of type CLOB. I suggest that moving
> the User table values to VARCHAR(4000) to store 4k of data within them
> *COULD* be a good thing. Can anyone see issues with this?
>
> Users.PGPKey

if this is storing a signed pgp key, 4000 characters seems a little on
the small side.

> This will allow common LIKE queries to work with the Users
>tables. Resulting in less work modifying DBIx::SearchBuilder to
>handle the CLOB data type (this actually won't result is less work -
>but means that some functionality will work without changes to
>SearchBuilder).

why would you ever search on pgp keys?

seph



More information about the Rt-devel mailing list