How to Page?

 

Topic #9188 : How to configure  Chinese language Support at database level

Applicable Ephesoft versions: 4.x and up

 

suppose user wants to configure key value pair for KV extraction in Chinese language then following changes are required at database level

Instructions:

1.  For MySQL/MariaDB:

 

To insertChinese language characters inkey_pattern and value_pattern column of kv_extraction table we have to change the Collation of these columns fromlatin1_swedish_ci to utf8_bin.  To alter key_pattern and value_pattern column’s collation execute following MySQL query:

 

ALTER TABLE `kv_extraction` CHANGE COLUMN `key_pattern` `key_pattern` VARCHAR(700) NULL DEFAULT NULL COLLATE ‘utf8_bin’ AFTER `key_fuzziness`;

ALTER TABLE `kv_extraction` CHANGE COLUMN `value_pattern` `value_pattern` VARCHAR(700) NULL DEFAULT NULL COLLATE ‘utf8_bin’ AFTER `use_existing_key`;

 

2. For MS SQL server:

 

To insertChinese language characters inkey_pattern and value_pattern column of kv_extraction table we have to change the data type of these columns fromvarchar to nvarchar. To alter key_pattern and value_pattern column’s data type execute following MSSQL queries:

 

alter table [ephesoft].[dbo].[kv_extraction]

alter column key_pattern nvarchar(700);

alter table [ephesoft].[dbo].[kv_extraction]

alter column value_pattern nvarchar(700);

 

 

 

< Back | How To Main Page| Next How To Article #? >

Was this article helpful to you?

Walter Lee