What is the smallest way to store a UUID that is h

问题:

What is the smallest way to store a UUID that is human readable and widely database compatible?

I am thinking a char array of some sort using hex values?

回答1:

As common approach, i think that encoding the binary data (16 bytes) as Base64 could be what you want.

回答2:

Use Base-85 encoding to store the UUID as 20 US-ASCII characters.

回答3:

You might find the latest podcast relevant:

http://itc.conversationsnetwork.org/shows/detail4087.html

Database-wide unique-yet-simple identifiers in SQL Server

回答4:

You want Base64 if it is going to be in any kind of computer representation. Base85 if you can figure out a way around putting it in a URL. See: http://en.wikipedia.org/wiki/Base64 and http://en.wikipedia.org/wiki/Ascii85