Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

生成表的时候,中文注释出现乱码 #71

Closed
Mjc960512 opened this issue Nov 28, 2020 · 5 comments
Closed

生成表的时候,中文注释出现乱码 #71

Mjc960512 opened this issue Nov 28, 2020 · 5 comments
Labels
bug Something isn't working

Comments

@Mjc960512
Copy link
Contributor

示例

/**
 * ??? 基类
 * @Entity
 * @Table(name="saas_departments", id={"departments_id"})
 * @DDL("CREATE TABLE `saas_departments` (
  `departments_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `departments_name` varchar(100) NOT NULL DEFAULT '' COMMENT '????',
  `departments_room` varchar(255) NOT NULL COMMENT '??(json)',
  `hospital_id` int(11) unsigned NOT NULL COMMENT '??id',
  `add_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  `delete_time` datetime DEFAULT NULL,
  PRIMARY KEY (`departments_id`) USING BTREE,
  KEY `hospital_id` (`hospital_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='???'")
 * @property int $departmentsId 
 * @property string $departmentsName ????
 * @property string $departmentsRoom ??(json)
 * @property int $hospitalId ??id
 * @property string $addTime 
 * @property string $updateTime 
 * @property string $deleteTime 
 */


/********************mysql中的编码查询************************
mysql> SHOW VARIABLES LIKE '%char%'
    -> ;
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8mb4                    |
| character_set_connection | utf8mb4                    |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8mb4                    |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.03 sec)
@Yurunsoft Yurunsoft added the bug Something isn't working label Nov 30, 2020
@Yurunsoft
Copy link
Member

mysql版本是多少,表是通过什么工具创建的?navicat还是命令行导入?

@Yurunsoft
Copy link
Member

imi中的mysql连接配置里,charset设置的是什么?

@Mjc960512
Copy link
Contributor Author

imi里配置的时候charset=utf8,mysql的表有的是命令行导入,也有的是navicat创建的。

mysql的信息是:

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.23    |
+-----------+
1 row in set (0.24 sec)

mysql> SHOW VARIABLES LIKE 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8mb4                    |
| character_set_connection | utf8mb4                    |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8mb4                    |
| character_set_server     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.21 sec)

@Yurunsoft
Copy link
Member

我这边没法复现,检查下导入时候的连接编码、sql文件编码是否是utf8

@Yurunsoft Yurunsoft added question Further information is requested and removed bug Something isn't working labels Nov 30, 2020
@Yurunsoft Yurunsoft added bug Something isn't working and removed question Further information is requested labels Nov 30, 2020
@Yurunsoft
Copy link
Member

经确认是 Mysqli 编码设置不生效问题,已修复,可以使用 dev-dev 版本测试先

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants