Skip to Content
0
Former Member
Jul 06, 2015 at 09:03 AM

how to Modif column length from 255 to varchar(4000) in hybris v5.0?

1475 Views

how to Modif column length from 255 to varchar(4000) in hybris v5.0?

I tried changing the persistence as below, but update didnt help.

                         <columntype database="oracle">
                             <value>varchar2(4000)</value>
                         </columntype>
                         <columntype database="sqlserver">
                             <value>nvarchar(max)</value>
                         </columntype>
                         <columntype database="mysql">
                             <value>text</value>
                         </columntype>
                         <columntype>
                             <value>varchar(4000)</value>
                         </columntype>
                     </persistence>

I tried with alter table command from sql server and it worked. but this code is already in production and we will not be having access to run alter queries.

Please suggest on how we can fix this issue.

Thanks in advance