Encoding issue with Contact form in v. 7.11.8


Suitecrn Version 7.11.8, php 7.2.21 on MariaDB.

Issue withe Contact view/edit form while saving records with accent (first name / last name / title…). Data are transformed to UTF8 (é --> é).
Accounts form is working fine.

Direct insert into database works and data are correctly displayed in view form.

Thks for your help!

I don’t see that using same SuiteCRM version with MySQL DB.

Would this be due to MariaDB ? can you switch to MySQL and use same code to verify?

thank you, current settings of MariaDB are as follows:
SHOW VARIABLES LIKE ‘character_set%’ ;
| Variable_name | Value |
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |

and default charset at table level is set to utf8. Database looks ok for me.

I do not see why it works with Accounts and not with Contacts.

I tried same code with mysql and…same issue.

Hi Icharbonnier

We are facing exactly the same issue. Were you able to solve this problem?

Let me know if you have any solution to this… Thanks