I transferred the system to UTF-8 from WINDOWS-1251, it went well, everything works, only the search fell off.

There is an index.php (UTF-8) header.php (UTF-8) connects to it (it forms the header where the search form is located), it also connects search.js (UTF-8), which reads the request entered by the user and requests search.php (UTF-8), which is looking for the whole thing.

The problem is that after the transition, it stopped outputting data from the contact table, and from the tasks it puts data into the search.

I can not understand the reason.

  • We tried debugging and watching what, first of all, sends js to php, secondly what kind of php query builds in mysql and what does the js end up sending back to the script? - RifmaMan
  • @RifmaMan But in general, change the mapping tables to utf8_general_ci and each column to put utf8_general_ci enough to change the encoding of the contents of this table? - Alexander Sizintsev
  • @RifmaMan by the way, I put the console output of what is taken from the form, and in the php file I return the sent request. It all matches, no cracking. - Alexander Sizintsev
  • What implies that the matter is not in the encoding? I will not say exactly what the problem is, but I would still do it, take the mysql request that builds php and run it through phpMyAdmin for example, to visually see that the answer is empty and figured out the syntax of mysql in that request. Regarding the change of encoding, you did everything right. - RifmaMan
  • @RifmaMan Yes, I wonder that everything worked fine before the transition. - Alexander Sizintsev

0