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 ?? -- Cu respect, Ovidiu Farauanu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
