cancel
Showing results for 
Search instead for 
Did you mean: 

System update does not change type of column

Former Member
0 Kudos

Hi Experts,

I am running SQL Server and my Hybris version is 5.2.0.6.

I have created a new item type as "java.lang.String" and this coresponds varchar in the database.

I have changed the data type for SQL server,

   <columntype database="sqlserver">
          <value>NTEXT</value>
   </columntype>

but is not working when I do "ant updatesystem". It stays as VARCHAR instead of TEXT. I have no other choice but make an " alter table" statement.

What should I do?

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

andyfletcher
Active Contributor
0 Kudos

Yep you are correct, system update won't change the column type once it has already been created. It potentially could be a destructive operation (e.g. if you changed a text column to a shorter varchar) and I guess Hybris don't really want to have to teach it all of the non-destructive operations for each db type so it just doesn't do any.

You do need to run an alter table.

Answers (0)