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
10416
November 27, 2009 07:54AM
6548
January 08, 2010 04:20AM
Re: Hrvatski collation dostupan
5663
January 08, 2010 05:43AM
4838
January 20, 2010 01:29AM
5013
January 20, 2010 02:18AM
4585
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.