What is the best way to store a guid? I found that the best way to store a guid is as a char(36) data type for MySQL.
What is the equivalent to char(36) in drupal 7?
In terms of core function I don't think there's a lot of choice you can have.  You'd have to use the "text" field type and limit to 36 chars.