MySQL Forums
Forum List  »  Serbian/Croatian/Bosnian

Re: Hrvatski collation dostupan
Posted by: Tin Siladin
Date: January 08, 2010 04:20AM

Da li ovo rješava i problem sa poistovjećivanjem naših dijakritičkih znakova sa znakovima bez 'kvačica' u LIKE upitima? Ili se collation koristi samo za sortiranje? Ispričavam se što nisam baš upućen u problematiku. Pokušao sam razne collatione (utf8_*) i upiti mi vraćaju sljedeće rezultate ...

>SELECT * FROM test.cities c WHERE name LIKE '%S%'
id name
1 Šibenik
2 Split

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

Isto se dešava sa đ,ž,č,ć ...

Hvala,
Tin

Options: ReplyQuote


Subject
Views
Written By
Posted
9124
November 27, 2009 07:54AM
Re: Hrvatski collation dostupan
5633
January 08, 2010 04:20AM
4655
January 08, 2010 05:43AM
4067
January 20, 2010 01:29AM
4252
January 20, 2010 02:18AM
3798
January 20, 2010 05:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.