解决pymysql.err.DataError (1406, “Data too long for column ‘remark‘ at row 1419“)

1. 问题背景

在向数据库导入大批量数据的时候报错：

DataError: (pymysql.err.DataError) (1406, "Data too long for column 'remark' at row 1419")

相关代码：

import pandas as pd
from sqlalchemy import create_engine
from urllib.parse import quote_plus as urlquote
import pymysql

userName = "xxxx"
password = "xxxxx"
dbHost = "your ip xxx.xxx.xxx.xxx"
dbName = "your dbname"
dbPort