code: public static final String collateCharset(String charset) {
          String[] output = StringUtils.split(charset, "COLLATE");
          return output[0].replace('\'', ' ').trim();
      }
docs: 'utf8' COLLATE 'utf8_general_ci'
  
  @param charset
  @return