Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The database and tables of Translate5 must be configured with the charset utf8 charset utf8mb4 and the collation utf8utf8mb4_generalunicode_ci.

If this is not the case the following steps can be done to fix it.

...

Code Block
-- make an overview which tables are not in utf8. If there are any translate5 related tables not in utf8 see the below steps to convert.
SELECT SCHEMA_NAME, DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA;
SELECT TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLLATION_NAME,CHARACTER_SET_NAME from information_schema.columns where CHARACTER_SET_NAME != 'utf8utf8mb4';

-- convert the default DB charset:
ALTER DATABASE YOUR_DB_NAME CHARACTER SET utf8utf8mb4 COLLATE utf8utf8mb4_generalunicode_ci;

-- convert the tables which are not in the right charset:
ALTER TABLE YOUR_TABLE_NAME_HERE CONVERT TO CHARACTER SET utf8utf8mb4 COLLATE utf8utf8mb4_generalunicode_ci;

...