When I load a CSV with a lot of large text columns, a CONNECT table is created and I can query the table. Some rows however, are returning the following error:
HeidiSQL, SQL command line and PDO are all giving the same error. The error log shows:
This is my create table statement:
Column my_column is auto created as varchar(3329). But when I scan the CSV file, the row on line 1292 contains a text string with a length of 6632.
Adding the column length explicitly solves the issue. I prefer however to let MariaDB create the column definitions as this simplyfies the upload process.
What can I do? Are there any parameters that I can change? Could this be Windows related? Any help is appreciated.