puppetlabs/puppetlabs-mysql — pull request #565 by mmonaco (2014-09-11 00:13:19+00:00)
Title: mysql_database: prevent syntax error with collate=>'binary'

On MySQL v5.5.38, creating a database such as:

CREATE DATABASE `mydb` CHARACTER SET binary COLLATE binary;

seems to hit a parser bug. A workaround is simply to quote COLLATE
`binary`. As the quoting is harmless, and for aesthetics, quote both
the CHARACTER SET and COLLATE arguments.