MYSQL: Error Code: 1366. Incorrect string value: ‘\xE0\xA4\xAA\xE0\xA5\x8D…’ for column

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)

Incorrect string value

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.

Unknown's avatar

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.

Have something to say ?

This site uses Akismet to reduce spam. Learn how your comment data is processed.