I assume your collation on the database table 'city' is utf8_general_ci
And also check the columns of the database table 'city' to ensure they are also
utf8_general_ci.
The database, its tables, and the tables individual columns can all have a
different collation.
Last, ensure that you set utf8
Hello.
I have a problem with queries on a utf8 table. For example when I send
select SQL_CALC_FOUND_ROWS * from city where country_code = 'pl' and
language_code = 'en' and ( city_name like 'A%' or city_name like "'A%"
) order by city_name
to MySQL, it returns to me not only cities that begin with
