 | | | utf8 queries | utf8 queries 2007-11-06 - By Russell E Glaue
Back
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/mysql?unsub=mysql@(protected)
|
|
|