Revert and fix faulty character encoding configuration

The SQL script files have the following general structure:

-- Update for null values

<UPDATE_SCRIPT>


-- Change the collation of the database

<COLLATION_CHANGE_COMMANDS>


-- Alter table

<ALTER_SCRIPT_TABLE>
<ALTER_SCRIPT_TABLE_COLUMN>


-- Analyze result

<ANALYZE_SCRIPT>

Step-by-step: revert and fix faulty configuration

1. Select the appropriate script and download it. If you do not find a script for your codebeamer version, open a support ticket for it.
2. Stop codebeamer and ensure no codebeamer process is running.
3. Update MySQL configuration. Locate the configuration file that typically resides in the MySQL installation directory.

   Operation System	Configuration File	Configuration File Location
   Windows	my.ini	C:\ProgramData\MySQL\MySQL Server 8.0
   Linux/Unix	my.cnf	/etc/mysql/my.cnf
   MAC-OS	my.cnf	/usr/local/mysql/my.cnf

   
   
   
   
   Add or change the following lines in the configuration file:
   collation-server=utf8mb4_general_ci
   init_connect='SET collation_connection = utf8mb4_general_ci'
4. Restart MySQL service.
5. Log in to MySQL.
6. Update for NULL values. Copy the -- Update for null values section of the downloaded/created SQL and run it.
7. Change the collation of the database. Copy the -- Change the collation of the database section of the downloaded/created SQL and run it.
8. Copy the -- Alter table section of the downloaded/created SQL and run it.
9. Copy the -- Analyze result section of the downloaded/created SQL and run it. Validate results.
10. Run the following command: SELECT * FROM <TABLE_SCHEMA>.version;
11. Based on the result of the previous query, run the following command: UPDATE <TABLE_SCHEMA>.version SET minor = '<previous_minor>' WHERE (major = '<your_current_major>') and (minor = '<your_current_minor>');
    e.g.: UPDATE codebeamer.version SET minor = '-final' WHERE (major = 'FELICITY') and (minor = '-SP1');
12. Start codebeamer.