IntegralDefense / ACE

Analysis Correlation Engine
Apache License 2.0
26 stars 10 forks source link

use the right unicode character set in mysql #198

Closed unixfreak0037 closed 5 years ago

unixfreak0037 commented 5 years ago

Looks like, for the most part, all the encodings and collations in the database are wrong. Most are using latin1 for encoding and swedish for collation (lol).

See https://medium.com/@adamhooper/in-mysql-never-use-utf8-use-utf8mb4-11761243e434

unixfreak0037 commented 5 years ago

Also see https://docs.sqlalchemy.org/en/latest/dialects/mysql.html#unicode

unixfreak0037 commented 5 years ago

master branch now has the corrected SQL schema