cookieY / Yearning

🐳 A most popular sql audit platform for mysql
http://next.yearning.io/
GNU Affero General Public License v3.0
8.43k stars 1.98k forks source link

[Question] #1046

Closed ziqingkeshi closed 4 months ago

ziqingkeshi commented 4 months ago

Please provide titles that are straightforward and concise. exp: [Question] How to use or [Feature] Add new feature

  请提供简单明了的标题。例如 [Question] 如何使用 or [Feature] 添加新功能
Issues-translate-bot commented 4 months ago

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿


Title: [Question]

When detecting the table creation statement, it prompts [ddl:1273]Unknown collation: 'utf8mb4_zh_0900_as_cs'

recurrent Take this and execute it CREATE TABLEmy_table( idbigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Access ID', urlvarchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_zh_0900_as_cs DEFAULT '' COMMENT 'path', PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Desired results Detection successful

screenshot

FIUS_K7BU~0@OZH)5P }OMH 9ZPV78A{$@AXMPA@{64)$JW

Deployment method Centos7.9 physical machine

Environment (please fill in environmental information):