[Building Sakai] Idea: Change the GUID generator for Sakai

[Charles Severance]

Stephen,

That is an important point - it means base-62 is off the table.   I would guess that would also make indexes tricky too.

/Chuck

On Jan 9, 2014, at 6:39 AM, Stephen Marquard <stephen.marquard at uct.ac.za> wrote:

> In mysql, these two are equivalent:
>  
> SELECT * FROM SAKAI_REALM WHERE REALM_ID='/site/bf438025-925a-481f-80b3-aa628eacd93b';
>  
> SELECT * FROM SAKAI_REALM WHERE REALM_ID='/site/bf438025-925a-481f-80b3-aa628eacd93B';
>  
> i.e. the comparison is case-insensitive by default. So I’m not sure that any encoding scheme including both A-Z and a-z is a good idea.
>  
> All round, this seems like a potentially very disruptive change for minimal gain.
>  
> Regards
> Stephen

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140109/49ea8acd/attachment.html