mkaufmaner commented on issue #6259:
URL:
https://github.com/apache/incubator-devlake/issues/6259#issuecomment-1801850808
> Can you check the character set? SELECT character_set_name, collation_name
FROM information_schema.columns WHERE table_schema = 'lake';
>
> And please set CHARACTER_SET_NAME="utf8mb4" and
COLLATION_NAME="utf8mb4_bin". related to #6205
@abeizn This worked. Also had to run a script to change the existing charset
and collation for all tables.
```
-- To get the SQL to run for all devlake tables
SELECT CONCAT('ALTER TABLE ', tbl.TABLE_SCHEMA, '.', tbl.TABLE_NAME, '
CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') FROM
information_schema.TABLES
tbl WHERE tbl.TABLE_SCHEMA = 'devlake'
```
--
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]
