Skip to content

new charset definition added #591

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

Closed
wants to merge 1 commit into from
Closed

new charset definition added #591

wants to merge 1 commit into from

Conversation

peakkk
Copy link

@peakkk peakkk commented Aug 21, 2017

When connecting to MySQL 8, PyMySQL may raise an exception, such as KeyError: 255.
To solve the problem, serval new charset definition was added to this file.

When connection to MySQL 8, PyMySQL may raise an exception, such as `KeyError: 255`.
To solve the problem, serval new charset definition was added to this file.
@methane
Copy link
Member

methane commented Aug 21, 2017

See #577

@peakkk
Copy link
Author

peakkk commented Aug 21, 2017

There is the charset definition from my brand new MySQL 8 server.
charset

And when I use PyMySQL to connect to the server, an exception about charset raised.
exception

@methane
Copy link
Member

methane commented Aug 21, 2017

Doesn't they conflict with other servers compatible MySQL protocol, especially MariaDB?
Is there any reason to add collation other than 255?
Especially, collation with id>255 can't be used in protocol.

@methane
Copy link
Member

methane commented Aug 21, 2017

Since MySQL 8 is not GA yet, I don't want to add them now
even if they doesn't conflict with MariaDB.

@methane methane closed this Aug 21, 2017
methane added a commit to methane/PyMySQL that referenced this pull request Aug 21, 2017
methane added a commit to methane/PyMySQL that referenced this pull request Aug 21, 2017
methane added a commit to methane/PyMySQL that referenced this pull request Aug 21, 2017
@meeuw meeuw mentioned this pull request Oct 3, 2017
@timloo0710
Copy link

I encountered the same problem,

How did I add 46 character set ? Where can I get the information of the character set 46?

My mysql server is stated on the Windows Server 2012 R2 .

Below is my error message!! Please Ref.

46

@methane
Copy link
Member

methane commented Mar 22, 2018

What version of MySQL do you use?
Why don't you use utf-8?

@timloo0710
Copy link

default

I can't figure out what I setup the language encode option.
Where can I modify the option??

Thanks!

@methane
Copy link
Member

methane commented Mar 23, 2018

https://github.com/PyMySQL/PyMySQL#example

Why don't you read README before asking question???

https://medium.com/@methane/why-you-must-not-ask-questions-on-github-issues-51d741d83fde#.uoo6bjv13

@GOODLIFEZW
Copy link

it solves my problem, thank you very much

@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jul 31, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

5 participants