 | | | utf8 queries | utf8 queries 2007-11-05 - By Ovidiu Farauanu
Back
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/mysql?unsub=mysql@(protected)
|
|
|