> As I see it, the problem is making the client know whether it has a GUID

or a CHAR value. Then we can talk about how to convert it.

I do not like the idea to add new datatypes just to distinguish contents
of table fields.
Otherwise I would propose to add new datatypes for
Money, Size, Volume, Speed, Tax rate, Shoe Size, RTF, HTML, ...

Ivan