Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
i want to change a custom Field
test= fields.Integer(string="Test")
to
test = fields.Char(string="TEst")
if i do this it works but all existing Values will be lost in DB. Is it possible to make this without loosing the existing values? (castet to Strings in DB)
You can change fields from integer to char. Then all values store in test_moved0(created new column). You can run below update query to fill values in new column.
update table_name set test = test_moved0;
i_m sorry but found the solution already here:
https://www.odoo.com/de_DE/forum/hilfe-1/question/change-data-type-of-field-on-active-db-142575
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
