Blob_to_char will will copy n bytes (up to 512) of a TEXT blob to a CHAR variable and return that CHAR variable.