Weird result at selecting rows

Question

I've been worndering why this query returns this result:

SELECT direccion_principal
FROM tb_dysport_contacto_medico_terapeutica
WHERE direccion_principal LIKE '%Ãš%'

Result:

+---------------------+
| direccion_principal |
+---------------------+
| COLSANITAS          |
+---------------------+

The table collation is utf8_general_ci.

score 2 · Answer 1 · answered Jun 22 '10 at 14:11

2

Before a query, indicate what charset the client will use to send SQL statements to the server with:

SET NAMES 'utf8';

answered Jun 22 '10 at 14:11

Ain Tohvri

score 2 · Accepted Answer · edited May 23 '17 at 12:18

2

This part of your query:

LIKE '%Ãš%'

is attempting to select results with accented characters. The utf8_general_ci collation removes accents: What are the diffrences between utf8_general_ci and utf8_unicode_ci?

edited May 23 '17 at 12:18

Community

answered Jun 22 '10 at 14:12

Chris Laplante

score 0 · Answer 3 · answered Jun 23 '10 at 10:03

0

SELECT direccion_principal
FROM tb_dysport_contacto_medico_terapeutica
WHERE direccion_principal LIKE '%Ãš%' collate utf8_bin

But this also makes it case sensitive.

answered Jun 23 '10 at 10:03

ceteras

3 Answers3