Multi Language Tool Query Error and Turkish Character Problem

I have installed the open source software on my server, but I am facing Turkish Character Problem. When I want to change multiple languages, I get the following error. Please help me.

OpenEMR Version
I’m using OpenEMR version 7.0.0 (2)

I’m using: Google Chrome

Operating System
I’m using: Macosx Monterey 12.6


Query Error

ERROR: query failed: SELECT lc.cons_id, lc.constant_name, ld.def_id, ld.definition, ld.lang_id FROM lang_definitions AS ld RIGHT JOIN ( lang_constants AS lc, lang_languages AS ll ) ON ( lc.cons_id = ld.cons_id AND ll.lang_id = ld.lang_id ) WHERE lc.constant_name COLLATE utf8mb4_general_ci LIKE ? AND ( ll.lang_id = 1 OR ll.lang_id=? ) ORDER BY lc.constant_name, BINARY lc.constant_name, ld.lang_id COLLATE utf8mb4_general_ci

Error: COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘latin1’

/home/ at 216:sqlStatement
/home/ at 96:require_once(/home/

Hi Özgür Çelebi ozgurcelebi,
Please Check your lang_definitions table and lang_constants tables structure below like this.

1.lang_definitions table structure
lang_definitions (1).sql (1.2 KB)

2.lang_constants table structure
lang_constants.sql (580.0 KB)