MySQL Forums
Forum List  »  Serbian/Croatian/Bosnian

Re: Hrvatski collation dostupan
Posted by: Tin Siladin
Date: January 08, 2010 05:43AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
10274
November 27, 2009 07:54AM
6457
January 08, 2010 04:20AM
Re: Hrvatski collation dostupan
5553
January 08, 2010 05:43AM
4762
January 20, 2010 01:29AM
4931
January 20, 2010 02:18AM
4499
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.