Is it safe to change INT to BIGINT or DECIMAL in database? I need to change a field from INT to BIGINT or DECIMAL. I tested changing it directly in the database on field_data and field_revision tables and apparently all is working fine, but I have my doubts and I don't want to do that on production until I'm entirely sure it's safe. It's enough to change the data type on database or I have to do something else like the solutions listed in the links below? If it's not safe to just change it in database, I'd like to know why.


change field from int to big int in drupal
How to change a field type from Integer to Decimal?
field is Integer and I am getting PDOException error thrown
Usually, when you make a change of this type it is recommended to make it in a development environment, so you can make some test to check your site is working correctly.

In the case you decide to make it in a production environment, be sure you make a backup of your database, in order to restore your system in case of problems.