[Java] Spring Data Jpa Mysql使用utf8mb4编码的示例代码

[client] 
default-character-set = utf8mb4 
[mysql] 
default-character-set = utf8mb4 
[mysqld] 
character-set-client-handshake = false
character-set-server = utf8mb4 
collation-server = utf8mb4_unicode_ci 
init_connect='set names utf8mb4'

show variables where variable_name like 'character_set_%' or variable_name like 'collation%';

public class mysql5innodbdialectutf8mb4 extends mysql5innodbdialect {
  @override
  public string gettabletypestring() {
  return "engine=innodb default charset=utf8mb4 collate utf8mb4_unicode_ci";
  }
}

spring:
 jpa:
  properties:
   hibernate:
  dialect: com.xxx.mysql5innodbdialectutf8mb4

@configuration
public class druidconfig {
  @value("${spring.datasource.druid.connection-init-sqls")
  private list<string> connectioninitsqls;
 
  @bean
  public druiddatasource datasource() {
  druiddatasource datasource = new druiddatasource();
  datasource.setconnectioninitsqls(connectioninitsqls);
  return datasource;
  }
}

spring:
 datasource:
  druid:
   connection-init-sqls: ["set names utf8mb4 collate utf8mb4_unicode_ci"]