MySQL problem: SET NAMES and default-character-set
How Do I?
I’m using EE1.
I have a Cyrillic symbols on the site. I updated MySQL and in the control panel I do not see the data typed by cyrillic symbols. I was told that I should use ExpressionEngine SET NAMES instead of the old default-character-set. Where can I change it?
v1 uses whatever your PHP environment’s collation is for its connection to MySQL. Everything on the display side would look fine, because PHP decodes the data in the same way it encoded it. Upgrading to v2 will both convert your content so that it is stored properly stored in the database as UTF-8, and it sets the connection collation properly. I would not advise taking any of those steps on v1, as you may encounter problems when you update to v2 with double encoding.
So can you clarify what you mean by updating MySQL? What exact steps did you take?
Sorry, but i dont know. :( My server administrator only update PHP and MySQL. I do not remember what versions were before. Now: PHP 5.4.45 and MySQL 5.5.54.
In phpMyAdmin i see all data. I see all titles in CP, but when editing — all fields with Cyrillic - empty. In CP, in the list of all entries avillable titles and with a cyrillic. It’s strange. May be it’s not encoding problem?
And one more: on site avillable all data, except for one field (the data there is no different, there are no special characters, etc.)
Thx for help Derek and sorry for my English 😉
I would ask your host to allow you to downgrade to the previous environment, so you that can upgrade your installation, and then put you back on the new environment. Without knowing what they changed in the environment, it’s impossible to tell you what steps to take to fix the problem. If they are unwilling to do so, it’s possible you could do so locally, but would still require that you know how the server was originally configured.
ok, thx. I try. 😊