[rt-users] Ticket ID as CHAR(32)?

Dusty Wilson [Megagram] dusty at megagram.com
Tue Jun 30 16:06:17 EDT 2009


I just sent an email about UNSIGNED INT for the database.  This is a
separate (but related) question:  Is there a reason why ticket IDs
can't be CHAR(32)?  I'd love to use a proper UUID as a ticket ID.

If I convert a UUID from hex (base 16) to alphanumeric (case
sensitive: base 62; case insensitive: base 36), I can use much less
space to store the UUID.

Anyone have any thoughts on that?

Thanks,
Dusty



More information about the rt-users mailing list