I'm using MySQL 8 and I'm unable to insert empty strings into a decimal column. I suspect this is due to the STRICT_TRANS_TABLES mode, which enforces strict data validation rules. To potentially address this issue, I'm considering disabling the STRICT_TRANS_TABLES mode in my MySQL configuration file.
However, I'm concerned about the potential impact on Metabase, which uses MySQL as its application database. Any advice on how to proceed and ensure that Metabase continues to function properly after making changes to the MySQL configuration?