Skip navigation links

MySQL Forums :: Serbian/Croatian/Bosnian :: Hrvatski collation dostupan


Advanced Search

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
Hrvatski collation dostupan 6947 Tonci Grgin 11/27/2009 07:54AM
Re: Hrvatski collation dostupan 4251 Tin Siladin 01/08/2010 04:20AM
Re: Hrvatski collation dostupan 3722 Tin Siladin 01/08/2010 05:43AM
Re: Hrvatski collation dostupan 3058 Tonci Grgin 01/20/2010 01:29AM
Re: Hrvatski collation dostupan 3290 Tin Siladin 01/20/2010 02:18AM
Re: Hrvatski collation dostupan 2881 Tonci Grgin 01/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.