Testing SQL UTF-8 4 byte emoji

sql-groovy-test.groovy

@GrabConfig( systemClassLoader=true )
@Grab( 'mysql:mysql-connector-java:5.1.38' )

import groovy.sql.Sql
class GroovySqlExample1{
  static void main(String[] args) {
    def sql = Sql.newInstance("jdbc:mysql://domovm.local.domo.com:3306/", "user","pass", "com.mysql.jdbc.Driver")
    sql.eachRow("SHOW VARIABLES WHERE Variable_name LIKE 'character\\_set\\_%' OR Variable_name LIKE 'collation%';"){ row ->
       println row.variable_name + " " + row.value
    }
    sql.execute "INSERT domo_dev.buzz_search (message_id, content) VALUES (8, '🖐') ON DUPLICATE KEY UPDATE content='🖐';"
    sql.eachRow("SELECT content FROM domo_dev.buzz_search WHERE message_id=8;"){row->
    	println row.content
	}
  }
}