I need to change an older Unique ID of 20 characters field in a table, so I thought using the UUID function, but it creates a 36 characters string which of course is truncated when used in a 20 characters defined field.
The problem is that that same field is used as a link in a couple of dozen other tables, so the solution to make the changes to all the tables and the fields involved is not the most joyful.
Is there a way to obtain a UUID with these 20 characters instead of the 36, would just take the first 20 characters of that 36 characters UUID still be a 'safe' bet for a UUID?
Or should I look into searching for a function which would create randomly a string of up to 20 characters to be used as a unique key?
Thank you for your input.