words with messing characters

sgalmeida

Greetings

I have a PHP/MySQL site and recently I changed it from host server, to another company. In the host server where it was installed previously it worked fine, no troubles but now on this one this got messed.

On the database I have text such José but when PHP shows these text on screen it comes as JOSÃ‰. But in database is stored José! I belive there is something on this new host server that messes with this kind of text. What should I change to things work properly as previous? On the previsou host site this didn't happen. I have not changed a single line of code, just uploaded it to the new host server.

On this link you can see the phpinfo() of the host server

TIA

sgalmeida

stewartship

you need to use the functions addslashes() - filters input data before being placed into database and stripslashes() when outputting data from database.

Another thing to look for is the magic_quotes_gpc and magic_quote_runtime are on in the php.ini file. These latter two directives automatically add and strip slashes for you.
All the manuals can help you with these if you are not familiar with them.
All in all these functions escape out characters that might be troublesome to a database. WHich seems to be happening here!
Hope this helps!

sgalmeida

stewartship wrote:
you need to use the functions addslashes() - filters input data before being placed into database and stripslashes() when outputting data from database.

Another thing to look for is the magic_quotes_gpc and magic_quote_runtime are on in the php.ini file. These latter two directives automatically add and strip slashes for you.
All the manuals can help you with these if you are not familiar with them.
All in all these functions escape out characters that might be troublesome to a database. WHich seems to be happening here!
Hope this helps!

it seems the database is UTF8. How can I change the character set? And what is the character set that I must use? The ASCII character set?

TIA