Hello everyone, tell me, I wrote a program that works with the mySQL Database, so when I tested it on Denver everything was normal and in Russian, but when I moved to hosting all the Russian words became ????????????? , although the encoding is not changed. So maybe you need to put another encoding to support Russian? I have cp1250_general_ci
Someone deleted his answer, and with it went my comments to the mountains.
You said that in the database itself on the hosting you display question marks. In phpMyAdmin hosting you, as I understand it, have access. Therefore, create a database, "Comparison" choose utf8_general_ci . Dump the local database does not pack! Go to the tab "Export", remove the bottom, if it is, tick "Save as file" and click "OK". We copy the whole dump in the field that appears, go to phpMyAdmin on the hosting. Select the created database, then click on the "SQL" tab, paste the saved dump from the buffer and click "OK". Here, as if all. If the base on LAN is large, then you may have to transfer each table separately. And it would be good to bring all the fields to the "Comparison" utf8_general_ci before removing the dump.
PS In general, the question sounds good: “ What encoding should I put on the table? ” Insert the most tomatoes)))
If the option to select the connection encoding is in the components that you use to connect to MySQL, then set cp1251.
Or, the same thing can be done via the MySQL command:
SET NAMES cp1251;
UTF8 and only UTF8 - always and in all!