Encoding issue with Contact form in v. 7.11.8

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello,

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!

2

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?

3

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.

4

I tried same code with mysql and…same issue.

5

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