I have a LAMP stack based web application that runs on MySQL 5.6.44 running mysqli extensions. I am using PHP 7.2.7. Currently this application works great with English characters. However I want to extend this application to use Unicode characters to support languages such as Portuguese, German, Spanish. My MySQL database tables are all set to support UTF-8 Unicode characters. When I read data from those tables and display on my .php pages through HTML tags no data is displayed.
In addition, I have some REST based web services (PHP) that reads data from the MySQL table based on query parameters, performs a json_encode and returns that JSON to a calling application. This works perfectly as long as the data for the json_encode is all English. However it the data contains Portuguese, Spanish or German characters, the entire JSON displays no data at all.
Only if you have experience resolving such issues, let me know. This project is not about coding anything from scratch. The requirement is to analyze the current source code and implement corrections that will support unicode characters on the HTML portion of the php pages and seamlessly render English and unicode characters on the JSON responses