Re: Hrvatski collation dostupan

[Tin Siladin]

Uspio sam dobiti razliku na način da specificiram COLLATE utf8_croatian_ci u SELECT-u ...

>SELECT * FROM test.cities c WHERE name LIKE '%S%' COLLATE utf8_croatian_ci
id name
2 Split

>SELECT * FROM test.cities c WHERE name LIKE '%Š%' COLLATE utf8_croatian_ci
id name
1 Šibenik

Sada mi samo nije jasno zašto to moram specificirati ako je na tablici zadan
collation.

Tin