ProjectsOfMLee opened a new issue, #6267: URL: https://github.com/apache/incubator-devlake/issues/6267
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar feature requirement. ### Use case DevLake version: 0.18.0 & 0.19.0-beta4 Deployment: helm chart Database: MySQL, External ### Description set CHARACTER_SET_NAME="utf8mb4"and COLLATION_NAME="utf8mb4_bin" is the solution in #6205 and #6259, this did not work, and after connecting to the db and running ``` SHOW VARIABLES WHERE Variable_name LIKE 'character%' OR Variable_name LIKE 'collation%' ``` yielded that there were no variables with these names; there were CHARACTER_SET_DATABASE and COLLATION_DATABASE that had default values of `utf8`, and if you have the ultimate admin/super role of db (which I don't), you could set them to `utf8mb4` and it should solve your problem with collecting data with special characters for now, well, until you redeploy your devlake instance. Then you'd have to do this all over again. Figured out a solution of running this SQL command in the db: ```sql ALTER {DATABASE | SCHEMA} [db_name] alter_option ... alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ``` however, I'd have to connect to the db manually, run it every single time whenever devlake is re-deployed due to updates or other issues; to make matters worse, this command often leads to a timeout causing corruption of the db itself causing a more serious situation where no GitHub etc. connection could be established and therefore no projects, blueprints, pipelines, all the following steps are blocked, making the service useless. ### Related issues #6205 #6259 ### Are you willing to submit a PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
