-
Notifications
You must be signed in to change notification settings - Fork 53
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Incorrect collation used for charset utf8mb4
#172
Labels
bug
Something isn't working
Comments
3 tasks
@mwallace582, thank you for reviewing and merging #173. Please let me know if there's something I could do to have a new alpha release of 1.7 that would include these changes. |
I'll work on releasing |
I've just released 1.7.0. Let me know if you encounter any issues. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Describe the bug
This is about
dbt-mysql
in version1.7.0a1
.Starting with mysql version 8, the default and recommended collation for charset
utf8mb4
isutf8mb4_0900_ci_ai
. When inspectingmysql.general_log
after running anydbt
command, the following entry appears:This leads to errors of mismatched collations when server setting is different from utf8mb4_general_ci.
Steps To Reproduce
Set up general_log:
Run any dbt command, e.g.
dbt run
.Check result int the dbt log:
Expected behavior
The last query shouldn't show
but either nothing or
or last statement should be
Screenshots and log output
If applicable, add screenshots or log output to help explain your problem.
The output of
dbt --version
:The operating system you're using:
macOs Sonoma 14.4.1
The output of
python --version
:Python 3.11.6
Additional context
The text was updated successfully, but these errors were encountered: