I'm running an Apache Server 2.0.52 on Windows XP ( only for local purposes ) and PHP 4.3.9 which came with MySql. I believe i configured Apache to work correctly with PHP, but i have this problem:
I have a database with several tables that are populated with words in Portuguese, so they have accents. As an example i may have Ângela Conceição in one of the rows of a whatever column. This i inserted in MySql. If i query the database for that field i'll get the right return, i.e. Ângela Conceição. I created a script on php to the same efect in order to populate a form and if i execute it with php as a cgi i get the right results again. If i execute it as a website page, i get results like this Ùngela Conceiý±o ( those are NOT reallistic ).
I've tried to use htmlentities, make compliant charsets, nothing seems to work. Even more, i'm still confused where the problem is. I believe it is with Apache, but if instead of getting the field from the databse, i ask PHP to print it, i.e. "print('Ângela Conceição');" it appears normally whether i execute it as a CGI or with Apache.
Finally, if i post Ângela Conceição to a php script to insert it in the database, i get the funny characters inserted.
Thank you so much for your help!
Best regards!
Luís Nunes