# Multilanguage Tool not working

**URL:** <https://community.open-emr.org/t/multilanguage-tool-not-working/19147>\
**Category:** Support\
**Created:** [September 16, 2022, 1:53am UTC](https://community.open-emr.org/t/multilanguage-tool-not-working/19147 "2022-09-16T01:53:10Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sergiors](https://community.open-emr.org/letter_avatar_proxy/v4/letter/s/977dab/32.png) [@sergiors](https://community.open-emr.org/u/sergiors)\
**Post date:** [September 16, 2022, 1:53am UTC](https://community.open-emr.org/t/multilanguage-tool-not-working/19147/1 "2022-09-16T01:53:10Z")

</div>

Searching for any constant, in any language gives this error:

Error: COLLATION ‘utf8mb4\_general\_ci’ is not valid for CHARACTER SET ‘latin1’

It occurs in the OpenEMR 7 demos currently online, both official release and development versions.

It occurs in all browsers.

Please help!

---

<div class="post-metadata">

**Author:** ![luisuriarte](https://community.open-emr.org/user_avatar/community.open-emr.org/luisuriarte/32/15503_2.png) [@luisuriarte](https://community.open-emr.org/u/luisuriarte)\
**Post date:** [September 16, 2022, 3:35pm UTC](https://community.open-emr.org/t/multilanguage-tool-not-working/19147/2 "2022-09-16T15:35:54Z")

</div>

You should disable the utf8 flag in sites/default/sqlconf.php  
`$disable_utf8_flag = true;`  
and completely remove the `$db_encoding = 'utf8mb4';`

---

<div class="post-metadata">

**Author:** ![brady.miller](https://community.open-emr.org/user_avatar/community.open-emr.org/brady.miller/32/10178_2.png) [@brady.miller](https://community.open-emr.org/u/brady.miller)\
**Post date:** [September 17, 2022, 6:56am UTC](https://community.open-emr.org/t/multilanguage-tool-not-working/19147/3 "2022-09-17T06:56:40Z")

</div>

hi @sergiors ,  
Thanks for reporting this. This appears to be a bug in our demos (looking into it now), but should not be an issue on your OpenEMR installation. Are you having this issue on OpenEMR instances that are not part of the OpenEMR demo farm?
