Developer

Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

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

First of all create a DB backup!
-- 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 != 'utf8';

-- convert the default DB charset:
ALTER DATABASE YOUR_DB_NAME CHARACTER SET utf8 COLLATE utf8_general_ci;

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


Reminder: In near future translate5 will switch to utf8mb4, since utf8 charset is not real utf8 (only 3 bytes).

  • No labels