supplementary

SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰

This is collation dependant. Matches empty string SELECT 1 where N” = N’🍰’ COLLATE latin1_general_ci_as Doesn’t match empty string SELECT 1 WHERE N” = N’🍰’ COLLATE latin1_general_100_ci_as The 100 collations are more up-to-date (though still not bleeding edge, they have been available since 2008) and you should use more modern collations unless you have some … Read more

How to make Supplementary View float in UICollectionView as Section Headers do in UITableView plain style

In iOS9, Apple was kind enough to add a simple property in UICollectionViewFlowLayout called sectionHeadersPinToVisibleBounds. With this, you can make the headers float like that in table views. let layout = UICollectionViewFlowLayout() layout.sectionHeadersPinToVisibleBounds = true layout.minimumInteritemSpacing = 1 layout.minimumLineSpacing = 1 super.init(collectionViewLayout: layout)