How Do You Increase the Database Column Length For An Itemtype Attribute?

In SAP Hybris Commerce 6.x, the default database column length for an Itemtype Attribute String type is 255 characters.  A client recently asked to increase the database column length for the Orders table P_NAME column from the default 255 variable characters length to 500 variable characters length. In this tutorial, I will show you how to properly increase the database column in SAP Hybris Commerce. For this tutorial, I'm using the default Hybris database, HSQLDB. Open the <Your Hybris DIR>/ext/core/resources/core-items.xmll file using your preferred text file editor. Once the core-items.xml file is open, find the attribute qualifier="name" under AbstractOrder itemtype node. For …