T
Thomas Mercer-Hursh
Guest
To wrap this up, thanks to the thoroughness of Youssif Shanshiry ... One can index a temp-table by a raw, but not a database table, so one *must* convert to character to use a guid as a primary key. There are three methods: base64-encode(generate-uuid) Yields a string 24 long, the last 2 of which can be discarded. The string is case-sensitive. guid(generate-uuid) Yields a string 36 characters long which is not case sensitive. hex-encode(generate-uuid) Yields a string 32 characters long which is not case sensitive. So, you makes your pick.
Continue reading...
Continue reading...