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 for your client connection as well. http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html -RG Ovidiu Farauanu wrote: > 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 capital letter A > but also with latin capital letter A with ring above, with diaeresis, > with acute and etc. > I don't want that. I will query it to do this. > > Please help. How so query to get only cities that begin with A and > only those that begin with A > ?? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]