Hello, we have whcms in hebrew but some pages doest not support UTF8 in DB so we contacted whmcs support and they told us to do that:
The issue is that the tables in your database are using at least 3 different collations: utf8_bin, utf8_general_ci, and latin1_swedish_ci. This can cause many issues with storing data in the database, as each one of these has different levels of support for character sets. The WHMCS installation procedure and official addons will always attempt to use utf8_general_ci, so this would suggest that at least some of the tables were manually altered after installation. To resolve this, you will need to convert all tables to utf8_general_ci, check any data contained within them, and correct it as needed. If you are unsure of how to do this, you will need to contact a qualified database administrator for help.
Regards,
Lawrence
Technical Analyst I
We need someone who can do it.
Hello there. I'm experienced Linux system administrator and I've been working with MySQL for a long time now, so I can help you. My plan for this project is:
1. Make full backup of your existing whmcs database.
2. Convert tables into utf8
3. Make sure everything is ok.
4. Payment(I don't require any upfront payments).
Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce, Zen cart-Drupal I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks & Regards: BCS SOFT