BMS Chinese (UTF 8) Character Support Database Checklist - IntegratedBreedingPlatform/Documentation GitHub Wiki

In case one encounters Chinese language support issues please ensure the following database related settings are present in your target database.

  1. To support Chinese characters your database collation must be set to utf8_general_ci. You can check your database collation using the following query:

SELECT * FROM information_schema.SCHEMATA where information_schema.SCHEMATA.SCHEMA_NAME LIKE 'ibd%' or information_schema.SCHEMATA.SCHEMA_NAME = 'workbench';

  1. You must also ensure that every character based column in your target DB has its collation set to utf8_general_ci. Please use the following query to check character based column collation settings:

SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME, DATA_TYPE

FROM INFORMATION_SCHEMA.COLUMNS where (INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA LIKE 'ibdb%' or

INFORMATION_SCHEMA.COLUMNS.TABLE_SCHEMA = "workbench") AND

INFORMATION_SCHEMA.COLUMNS.DATA_TYPE IN ('varchar', 'char');

  1. Any database or a column that does not have its collation set to utf8_general_ci must be modified. Databases/columns with the wrong collation is generally a result of importing existing database.

  2. In your C:\BMS4\infrastructure\my.ini also ensure that the following properties have been set

# [client] default-character-set=utf8

[mysql] default-character-set=utf8

  1. Any database or a column that does not have its collation set to utf8_general_ci must be modified. Databases/columns with the wrong collation is generally a result of importing existing database.

  2. Please note Chinese character sets are not support in the Pedigree Viewer or the Ontology Manager.