Social Auto Poster - Change table collection and character set

wp-sap-change-table-collection.php

<?php

/**
 * Add this in child theme function.php file.
 */
add_action('wp', 'wp_change_table_collection');

function wp_change_table_collection() {
    
    global $wpdb;
  
    if( empty( get_option('wpsap_wp_options_collation_changed') ) ) {
      $wpdb->query("ALTER TABLE wp_options CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci");
      update_option('wpsap_wp_options_collation_changed', 1 );
    }    
}