labbinat Posted October 30, 2023 Share Posted October 30, 2023 Hello, I have a problem that Arabic texts coming from the database on my site appear as symbols, despite the database’s character encoding being set in Arabic and the pages and tables being encoded, but it appears that the server localhost:3306(MariaDB) is using Latin encoding. How can I correct this? Link to comment Share on other sites More sharing options...
wolstech Posted October 30, 2023 Share Posted October 30, 2023 You can't change the server encoding because it would affect everyone and likely break other users. If the server encoding needs to be changed, you'd need to buy a VPS instead so you have your own server to run with a different encoding. That said, I'm not sure if there is another way to make this work. Krydos would be the one to answer. Link to comment Share on other sites More sharing options...
labbinat Posted October 30, 2023 Author Share Posted October 30, 2023 Well, what is the solution to display the data received from the database correctly? Link to comment Share on other sites More sharing options...
Krydos Posted October 31, 2023 Share Posted October 31, 2023 Before you can receive any support we need to address your violation of our terms of service. Please review https://wiki.helionet.org/hosting/terms Each user is allowed to have 1 account. Which account would you like to keep? The other account will be permanently suspended. Link to comment Share on other sites More sharing options...
labbinat Posted October 31, 2023 Author Share Posted October 31, 2023 Can you explain more what you mean by misuse? And how can this be addressed? Link to comment Share on other sites More sharing options...
Krydos Posted October 31, 2023 Share Posted October 31, 2023 You created 2 accounts. You're only allowed to create 1 account. Which account would you like to keep? Link to comment Share on other sites More sharing options...
labbinat Posted October 31, 2023 Author Share Posted October 31, 2023 I want to keep this account, but please help me solve my problem Link to comment Share on other sites More sharing options...
Krydos Posted November 1, 2023 Share Posted November 1, 2023 Ok, your other account has been permanently suspended. I took a look at your database, and the charset is set to utf8mb4_general_ci which supports Arabic. I took a look at some of your data and it's correctly displayed in Arabic. I checked your website and everything looks correct too The formatting looks a little weird since the Arabic is right justified, but even a raw database query on the command line loads the Arabic text correctly. On 10/30/2023 at 3:52 PM, labbinat said: Arabic texts coming from the database on my site appear as symbols Can you describe more accurately what you mean by "texts coming from the database" means? Are you using some software to display the Arabic texts? Does the software know how to handle utf8mb4_general_ci? Have you tried any other UTF-8 charsets such as utf8mb4_unicode_ci? Link to comment Share on other sites More sharing options...
Krydos Posted November 1, 2023 Share Posted November 1, 2023 Also please stop clicking the report button. You need to click the reply button at the bottom right. If you keep reporting all of my posts instead of replying to them we might have to ban you for abusing the report function. Link to comment Share on other sites More sharing options...
labbinat Posted November 2, 2023 Author Share Posted November 2, 2023 Hello, I have several problems with the account, the first of which is the encoding of Arabic letters, and even in the section that appears in the search results, I cannot add Arabic words. The second is a problem with "phpmailer" asking me to install packages and other problems. Note that the files were working well before. What is the solution to that? I do not know where the reply button is because of my poor English. If my message is wrong, please help me find the appropriate place to reply. Link to comment Share on other sites More sharing options...
Krydos Posted November 2, 2023 Share Posted November 2, 2023 Did you write this software yourself? Link to comment Share on other sites More sharing options...
labbinat Posted November 2, 2023 Author Share Posted November 2, 2023 (edited) نعم . الرجاء مساعدتي في حل المشاكل في أسرع وقت ممكن Translation: Yes . Please help me solve the problems as quickly as possible Edited November 3, 2023 by Talk Sick Translation. Link to comment Share on other sites More sharing options...
labbinat Posted November 3, 2023 Author Share Posted November 3, 2023 I have a question, please. Does subscribing to VPS solve all problems? Link to comment Share on other sites More sharing options...
wolstech Posted November 3, 2023 Share Posted November 3, 2023 You will need to be much more specific in what exactly isn't working (such as posting error messages, examples of incorrect data, etc.) if you would like assistance as we don't know what's broken. Your site appears to be working to us, but we cannot tell if the content is correct or not since nobody on our team can speak or understand Arabic. A VPS would allow you to change the server character encoding if that's what you're asking, but I don't know if that will solve the problem you're experiencing since we don't know what the problem is. Link to comment Share on other sites More sharing options...
labbinat Posted November 4, 2023 Author Share Posted November 4, 2023 The problems I face are encoding the Arabic language for the data coming from the database and installing the PHPMAILER package to send and receive emails Link to comment Share on other sites More sharing options...
Recommended Posts