title: Mysql 5.7.20: Cannot create a JSON value from a string with CHARACTER SET 'binary'
body: <p>I am facing this issue when importing an SQL file with a table with JSON column. </p>
  
  <p>The database has</p>
  
  <p>Encoding: <code>utf8mb4</code></p>
  
  <p>Collation: <code>utf8mb4_unicode_ci</code></p>
  
  <p>Here's the table with the json column:</p>
  
  <pre><code>CREATE TABLE `tracking_data` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `route` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `data` json NOT NULL,
    `user_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  </code></pre>
  
  <p>I have read answers from this <a href="https://stackoverflow.com/questions/38078119/mysql-5-7-12-import-cannot-create-a-json-value-from-a-string-with-character-set">question</a> on stack overflow which suggest the table must be on <code>utf8mb4</code>. Mine's already, but I am facing this issue still. </p>
  
  <p>This is error is still thrown: </p>
  
  <blockquote>
    <p>Line XXX: Cannot create a JSON value from a string with CHARACTER SET
    'binary'.</p>
  </blockquote>
  
  <p>When I run <code>show session variables like 'char%';</code>: </p>
  
  <pre><code>    Variable_name   Value 
  
  character_set_client    utf8mb4 
  
  character_set_connection    utf8mb4 
  
  character_set_database  utf8mb4 
  
  character_set_filesystem    binary 
  
  character_set_results   utf8mb4 
  
  character_set_server    latin1 
  
  character_set_system    utf8 
  
  character_sets_dir  /usr/share/mysql/charsets/ 
  </code></pre>
  
  <p>How can I fix this? 
  Thanks!</p>