Character set not matching
-
I have a CRM database and with this plugin I retrieve textfields and textareas out of it to display on my website. This all works fine, except for one thing: special character that I have in my CRM database are not displayed properly, e.g. é becomes e? and the euro sign does not show at all.
My database has a utf8_general_ci collation. But obviously the content is not imported as such.
In /wp-content/plugins/cf7-datasource/cf7-datasource.php on line 373 I see:
contentType: “application/json; charset=utf-8”,Is this the place to change the charset? And how should I change it then?
-
Hello @dutchalfred
Thank you very much for using our plugin.
I tried to replicate the issue. I create a database table with the same encoding:
And entered the characters you are referring to in your entry:
And finally, the data is read with the correct encoding:
Are you sure that the information is stored in the database with the correct encoding?
Could you please send me the link to your page to check the issue in detail?
Best regards.
I use it in an automated proposal module, an example is: https://www.allianceexperts.com/sq/a/?oppid=a05f0bba-543c-6fb9-9c80-61ee82da2d3c
I put the symbols in the top right green block, with propprice1 as field name
I used a bit of custom code to display it as plain text in stead of a read-only field: in https://www.allianceexperts.com/wp-content/plugins/cf7-datasource/assets/script.js
Line 211 to 218
if(field[0].tagName == ‘TEXTAREA’ || field[0].tagName == ‘INPUT’) {
var element = document.getElementById(field[0].name);
if(element) {
element.innerHTML = value;
}
}However, I have the same result if I just display this as a normal editable or readonly form field.
- The topic ‘Character set not matching’ is closed to new replies.
