Friday, November 9, 2018

Error: ERROR 1406 (22001) at line 4950: Data too long for column 'xx' at row 1

因為舊DB導入新版本的mysql中所導致,執行下面設定就可以解決︰
SET @@global.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Reference: “Data too long for column” - why?

No comments: