Basically, this is most probably an issue related to the default collation/charset of the WordPress database combined with collation/charset set on the SQL Table you are pulling the data from, where all the tables are created/stored.
It is not allowing 'special characters' to be stored/or in other words, characters which are 'outside' of the current Database collation/character set.
Can you tell me are you calling this table from a custom SQL Table you made directly on the Database?
If you can please show us some screenshots of which collation/charset is currently configured on this specific SQL Table from which the data is being pulled and what is your current Database collation?
Can you then also check if you are matching the same Database collation/charset on your WordPress SQL Database?
If you have a different collation/charset in the WP Database, can you try changing it and make it match the same one - see if then our SQL Table loads the correct characters.
I also found a Post from Stack Overflow, where it seems another user had a similar issue in their Database, you can check this out.
If that does not help, we can remote in to check this for you.
Please provide me a temporary WP-admin (administrator) user for your website where this happens,
as well as FTP credentials and access to the database ( either link with credentials for PHPmyAdmin, or access to Hosting Panel),
so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Arabic content loading from sql server db tables not showing correctly
Attached files: wpdatatables.PNG
Hello,
Basically, this is most probably an issue related to the default collation/charset of the WordPress database combined with collation/charset set on the SQL Table you are pulling the data from, where all the tables are created/stored.
It is not allowing 'special characters' to be stored/or in other words, characters which are 'outside' of the current Database collation/character set.
Can you tell me are you calling this table from a custom SQL Table you made directly on the Database?
Is the data being called from the WordPress Database or from an Separate Database Connection?
If you can please show us some screenshots of which collation/charset is currently configured on this specific SQL Table from which the data is being pulled and what is your current Database collation?
Can you then also check if you are matching the same Database collation/charset on your WordPress SQL Database?
If you have a different collation/charset in the WP Database, can you try changing it and make it match the same one - see if then our SQL Table loads the correct characters.
I also found a Post from Stack Overflow, where it seems another user had a similar issue in their Database, you can check this out.
And you can check this Post from WordPress Codex, which shows examples of how to convert WP DB character sets.
If that does not help, we can remote in to check this for you.
Please provide me a temporary WP-admin (administrator) user for your website where this happens,
as well as FTP credentials and access to the database ( either link with credentials for PHPmyAdmin, or access to Hosting Panel),
so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
And point me to the table ID, please.
Thanks.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables