While trying to modify Max-length of column ‘Phone’ in MySQL Database, I got this error:-
(Error Code: 1366. Incorrect string value: ‘\xE0\xA4\xAA\xE0\xA5\x8D…’ for column ‘Phone’ at row 26691)

STATEMENT:-
ALTER TABLE User_Base MODIFY COLUMN Phone VARCHAR(50) NULL;
Initially I was surprised seeing this error. But later I noticed that datatype of column was ‘NVARCHAR’ & I was trying to change it to ‘VARCHAR’. Since data was invalid for ‘VARCHAR’ type it threw the error.
Author: Makarand Thengdi
Director of Engineering, DevOps, and Releases at LeadSquared, with over a decade of experience in leading engineering and DevOps transformations for high-growth companies. Passionate about optimizing software delivery pipelines, cloud infrastructure, and security compliance. In this blog, I share my learnings and insights on DevOps, cloud technologies, and modern software engineering, reflecting my journey from code to cloud.
View all posts by Makarand Thengdi