S A wrote:
>
> Can MySQL help with generation of ALPHANUMERIC unique identifiers ?
>
> ID's that use the full ASCII char range create more possible combinations with the
>same # of characters which can be important when squeezing into cookie storage space.
>
> 4 character numeric ID has 10,000 combinations.
>
> 4 character (6 bits per char) alphanumeric id has 16,777,216 combinations
>
> If MySQL can't help then I can do it with Perl/PHP I suppose but just curious.
>
>
>
> ---------------------------------
> Do You Yahoo!?
> Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
And 4 byte unsigned integer has 256 times that.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php