表存表情---字符集

逃离我推掉我的手 2023-06-13 06:30 9阅读 0赞

[https://www.cnblogs.com/liaohui5/p/10581554.html][https_www.cnblogs.com_liaohui5_p_10581554.html]

## 将一个表所有字段修改为指定字符集 ##

alter table `user_info` convert to character set utf8mb4 COLLATE utf8mb4_general_ci;

表多怎么办？用下面的方法：

SELECT 
    CONCAT("ALTER TABLE `", TABLE_NAME,"` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;") 
    AS target_tables
    FROM INFORMATION_SCHEMA.TABLES
    WHERE TABLE_SCHEMA='数据源名'
    AND TABLE_TYPE="BASE TABLE"

语句执行后，出出现如下结果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDY4MTc0_size_16_color_FFFFFF_t_70][]  将结果复制进行执行就ok了。

转载：[https://segmentfault.com/a/1190000019006928][https_segmentfault.com_a_1190000019006928]

坑点： Springboot项目除了设置数据源外，代码证连接数据库时要使用

spring:
      datasource:
        url: jdbc:mysql://10.xx.xx.142:3306/eb_qbee_run?useUnicode=true&characterEncoding=UTF-8
        username: root
        password: Qingbee2019..
        driver-class-name: com.mysql.cj.jdbc.Driver

com.mysql.cj.jdbc.Driver

\-------通用版

连接jar包

<dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>

连接方式如上，不再赘述！

如果发现数据库可以存表情，而代码中插入不进去表情时，请检查此jar包的版本，网上说是要高于**5.1.34**

[https://blog.csdn.net/z69183787/article/details/71196197][https_blog.csdn.net_z69183787_article_details_71196197]

[https_www.cnblogs.com_liaohui5_p_10581554.html]: https://www.cnblogs.com/liaohui5/p/10581554.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDY4MTc0_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200221181010456.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM0NDY4MTc0,size_16,color_FFFFFF,t_70
[https_segmentfault.com_a_1190000019006928]: https://segmentfault.com/a/1190000019006928
[https_blog.csdn.net_z69183787_article_details_71196197]: https://blog.csdn.net/z69183787/article/details/71196197