title: Loading data to DataTable in C# gives "Unknown SQL type - 0" error
body: <p>I've been successfully using the following code to load data from an ODBC connection into a <code>C#</code> <code>DataTable</code> for some time without issues:</p>
  
  <pre><code>public static DataTable ExecuteSqlSelect(string sql, string connectionString)
          {
              var result = new DataTable();
              using (var connection = new OdbcConnection(connectionString))
              {
                  connection.Open();
  
                  var command = connection.CreateCommand();
                  command.CommandText = sql;
                  var dbReader = command.ExecuteReader();
                  result.Load(dbReader);
  
                  connection.Close();
              }
  
              return result;
          }
  </code></pre>
  
  <p>However, I now have a <code>MySql</code> table with a column of type <code>JSON</code>. When I try to load data from that table with that method, I get the following error:</p>
  
  <pre><code>Unknown SQL type - 0.
  </code></pre>
  
  <p>I assume this is because the <code>JSON</code> type is not recognized by C#'s <code>DataTable</code>. Is this correct? And more importantly: is there a solution/workaround for this?</p>
  
  <p>EDIT: I'm <strong>not</strong> trying to convert a JSON string to a DataTable, as a commenter suggested... I'm trying to load a SQL table that contains a columns of <strong>MySQL type 'JSON'</strong> into a DataTable. I don't need JSON parsing, it would be fine if I just got the raw JSON string into the DataTable.</p>
  
  <p>EDIT 2: both MySql and the ODBC connector are the latest version: 8.0.11 </p>