Hey everyone!
With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:
Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.
We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.
In the meantime, if you need help, feel free to:
-
Use the support widget on the bottom right of our websites (Amelia and wpDataTables) — our AI-powered assistant is available 24/7 and can help with many common questions.
-
Visit our documentation, articles, or YouTube channels for quick answers and step-by-step guides.
https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos
https://www.youtube.com/@wpDataTables/videos
Thank you for being so understanding, and we hope you enjoy the long weekend!
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
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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