Skip to content

didaah/weixin

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

57 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

微信昵称包含 utf8mb4 字符,目前核心数据库类尚不支持创建表时使用 utf8mb64编码
为防止微信用户信息写入出错,本模块安装完成后,请在数据库中执行以下语句:

ALTER TABLE `user_ext` 
  DEFAULT CHARACTER SET=utf8mb4,
  COLLATE=utf8mb4_general_ci,
  MODIFY COLUMN `ext_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '第三方用户名' AFTER `uid`,
  MODIFY COLUMN `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '其它数据' AFTER `ext_id`;


ALTER TABLE `users` 
  DEFAULT CHARACTER SET=utf8mb4,
  COLLATE=utf8mb4_general_ci,
  MODIFY COLUMN `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称' AFTER `uid`,
  MODIFY COLUMN `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '其它数据' AFTER `session`;

ALTER TABLE `files` 
  DEFAULT CHARACTER SET=utf8mb4,
  COLLATE=utf8mb4_general_ci,
  MODIFY COLUMN `filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '文件名' AFTER `ext_type`;

ALTER TABLE `logs` 
  DEFAULT CHARACTER SET=utf8mb4,
  COLLATE=utf8mb4_general_ci,
  MODIFY COLUMN `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '事件描述' AFTER `url`;

并在 setting.php 文件中添加 set_names 参数,示例:

  'port' => '3306',
  'set_names' => 'utf8mb4',
  'prefix' => '',


About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages