potiuk commented on issue #18939: URL: https://github.com/apache/airflow/issues/18939#issuecomment-953854103
Oh yeah. We recommended `utf8mb3` for a LOOONG time (especially that it would not work for utf8 in MySQL8 due to index size) but only recently ``utf8mb3` is "default" when you create a new database. Rant: MSSQL collations and encoding are a total nightmare. Starting from the fact that it defaulted to latin1 for a long time and with Swedish collation (true story) ending with he fact that there are I think 5 places you can specify different collations and on top of that client's encoding/collation surprisingly defaults to what you have on the system rather than what you have in server (and you have to specify it separately on top of server one when you want to change it). I can't recall a single encoding problem for Postgres. Ever. And I saw many of those for MySQL. -- 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]
