Charset problem PHP + MYSQL + new server

Question

I work for a reseller of lodgings and I have a strange problem...

I recently acquired a server in ALOG, before I had a server in the hostgator, so I exported it through the Cpanel schema of all accounts.

Every site on this server has a PHP control panel to feed a Mysql database, the data registered in this panel before the migration, even after the migration are perfect, special characters, all clean.

First strange fact.

To) Once on the new server, I decide to register the word "Are", he saves "Are in the bank, da para ver pelo phpMyAdmin.

B) On the old server, when saved the word "are", I see in phpMyAdmin the word are like this : "SANE"

Cool that always worked like this, when in the frontend of the site I search in the bank, it returns me always the correct word.

As I exported the account, all charset settings of the sign-up files/view files are equal, so are the database settings.

Okay, I always wondered why it worked in the B way, but I was happy because it worked.

in my WHM, my php.ini is configured with charset iso-8859-1 same as my old server.

1st Problem:

But there appears the first problem, the words on the panel appear without the correct accentuation, for example "Description", appears "Description§§§§§§", now how? the charset is the same! the file is the same, the database has been exported and imported..

if I switch to utf-8, ready! works and appears right, but then the server is different the configuration, the new utf-8, the old iso-8859-1, I live with it, alive, but the problem is that there are more problems so I try to leave the 2 equal to go eliminating possibilities.

2nd problem: This is strange... I created a page, this page is with the metatag

<meta charset="utf-8" > 

but her encoding is iso-8859-1. the bank is like latin1_swedish_ci that is iso-8859-1 right? the table, everything, exactly like the database configuration of my old server, which works.

But when I register words, if they end with special characters, the problem

for example the phrase "is dull ó data, ã, implicit, meeting" when saved, it saves "is dull ó data, ã, implicit, meeting" in the bank and at the time of showing it shows "is dull ó data, ã, implicit, meeting"

but if I put some special character at the end, like "reuniã" it disappears me with the last character and shows nothing!

But if I put 2 special characters, then he obeys, like "meek," then he shows. Can you understand? if I put the only letter "Is" doesn’t work, if I put "ÉÉ" works!!

if you don’t believe, take a look http://www.heytec.com.br/test/

---

And that’s as much as I could, because even though I knew this configuration was correct because it works on the other server, I changed it and says all possible combinations.

had time to return me "?" and worse, this was as far as I got!

Can any charitable soul give me a light?? I haven’t slept for 2 days because of it.

DIRECT SEARCH IN PUTTY IN DATABASE - NEW SERVER

                             |
-> +----+----------------------------------------------+
-> |  1 |                                              |
-> |  2 | 1                                            |
-> |  3 | é maçaa ó dados, ã, implícito, reunião       |
-> |  4 | é maçaa ó dados, ã, implícito, reunião       |
-> |  5 | é maçaa ó dados, ã, implícito, reunião       |
-> |  6 | é maçaa ó dados, ã, implícito, reunião       |
-> |  7 | é maçaa ó dados, ã, implícito, reunião       |
-> |  8 | Acentuação 123                               |
-> |  9 | Acentuação 456                               |
-> +----+----------------------------------------------+
-> 9 rows in set (0.00 sec)

DIRECT SEARCH IN DATABASE, OLD SERVER

 select * from dados;
+----+-----------+
| id | valor     |
+----+-----------+
|  1 | maça |
|  2 | olá  |
|  3 | teste     |
+----+-----------+
3 rows in set (0.00 sec)

---

One detail I forgot to mention, is that if I search the variable for POST, it already has the problem, and if I put the special character directly in the query, it works, the problem is in the rescue of it in PHP, now because I do not know, apache? config in the php.ini?

I just returned the php.ini as utf8, so I can have the data that has already been registered in order.

so gets my test environment screen

"� ma�aa � dados, �, impl�cito, reuni�o"

---------------------- CONFIG PHP NEW SERVER

www.heytec.com.br / test/ test.php

---------------------- CONFIG PHP OLD SERVER

162.144.115.36 / ~heytecco / test/

Answer 1

I believe you have created the new database with the wrong charset, and the tables of this database are inheriting this new charset.

See which is the charset of your old database and configure the new one with it.

This does not explain why the database values are being written as html entities, but it does not cost to try.

Answer 2

I’ve been in the same trouble.

Keep this tag in your html:

<meta charset="utf-8" >

And in PHP, use the utf8_encode function().

Example, considering that the $variable came from a SELECT:

utf8_encode($variavel);

This normalizes the accents and removes the html.