CODEWITHSUNDEEP
sqldatabaselanguage-agnosticguiduuid
mainstringargs
mainstringargs

Reputation: 13923

What is the smallest way to store a UUID that is human readable?

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?

Upvotes: 3

Views: 4664

Answers (4)

Dennis
Dennis

Reputation: 757

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

Upvotes: 0

erickson
erickson

Reputation: 269897

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

Upvotes: 4

Lucero
Lucero

Reputation: 60276

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

Upvotes: 6

Brian
Brian

Reputation: 118935

You might find the latest podcast relevant:

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

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

Upvotes: 1

Related Questions