I want to increase the customer firstname max length so I have updated the length of that column using my custom module dbschema.xml.

After updating the length, I can see the updated length in PHPMyAdmin but when I check the column length using the below query, it's showing the older length

select column_name, data_type, character_maximum_length from information_schema.columns where table_name = 'customer_entity';

Can anyone please confirm whether this is the right way to increase the field length?

  • I think you have to convert firstname into text type and so length column would be empty
    – Ankit
    Oct 18, 2022 at 13:23

1 Answer 1


This is the way according to Magento 2 doc

<column xsi:type="varchar" name="title" nullable="false" length="255" comment="Title"/>

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.