Craft CMS: Data too long for column 'cacheKey' at row 1
Is there a Craft recommended approach to this issue please?

The simplest solution would be to update to Craft 3.5+
Template cache data went from being stored in the database to the file system, so this won't be an issue for you anymore.