Change text field to multi cultrure

Can i change a textfield on a product to multi culture through the database, or will that cause trouble (It’s ok if i loose the data in it right now)? That option is not avalible in back office.

Litium version: 5

I recommend that you create a new textfield with multiculture if you like to avoid issues.

Changing the field in the database will make all products that have data for that field to be corrupt and will prohibit loading and saving of the data. As @steve.redstorm mention it is best to create a new field. If you first delete the old field and then create a new field you should be able to have the same field name for the field.

My idea is to delete all old data in the database with
delete from [databasename].[Products].[BaseProductFieldData]
where FieldDefinitionId like ‘fieldname’

then update the field with

update [databasename].[Products].[FieldDefinition]
set MultiCulture = 1
Where Id like ‘fieldname’

This works for me in test. But do you see any problems with this?

Deleting the old field and creating it again could work to, mabye i should do that instead?
Changing the name is not the best solution for me

But in this case is’nt it easier to just delete old one and recreate the new and be on the safe side? :slight_smile:

Yes, removing and adding the field seems to be the best option! Thanks

1 Like