Problem with COLLATE ES_ES_CI_AI [CORE1774] #2198
Labels
affect-version: 2.0.0
affect-version: 2.0.1
affect-version: 2.0.2
affect-version: 2.0.3
affect-version: 2.1 Alpha 1
affect-version: 2.1 Beta 1
affect-version: 2.1 Beta 2
affect-version: 2.1 RC1
affect-version: 2.5 Initial
component: charsets/collation
fix-version: 2.0.4
fix-version: 2.5 Alpha 1
priority: major
qa: done successfully
type: bug
Submitted by: Jesús Gálvez (xus)
Jira_subtask_outward CORE1781
CREATE TABLE TABLE_A (
FIELD_A VARCHAR(100) CHARACTER SET ISO8859_1 COLLATE ES_ES_CI_AI
);
INSERT INTO TABLE_A (FIELD_A) VALUES ('Hace buena noche');
INSERT INTO TABLE_A (FIELD_A) VALUES ('Voy a hacer de comer');
INSERT INTO TABLE_A (FIELD_A) VALUES ('The web is hacked');
When I run the query:
SELECT * FROM TABLE_A WHERE FIELD_A LIKE '%HACK%'
Results:
FIELD_A
Hace buen día
Voy a hacer de comer
The web is hacked
Why shows 'Hace' and 'Hacer' if I'm search for 'hack'?
Commits: 628ad70
====== Test Details ======
See also other tickets related to collation ES_ES_CI_AI: CORE1384, CORE2361, CORE1172, CORE1178
The text was updated successfully, but these errors were encountered: