Skip to content

Incorrect length value field information #799

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.

Sign up for GitHub

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

Jump to bottom
Closed
webjoel opened this issue Apr 25, 2014 · 3 comments
Closed

Incorrect length value field information #799

webjoel opened this issue Apr 25, 2014 · 3 comments
Labels
question

Comments

@webjoel
Copy link

webjoel commented Apr 25, 2014

In field information of fields result have incorrect value for "length" when field is string, it appears that it is multiplied by 3...
@dougwilson
Copy link
Member

The length comes from the MySQL server and is the number of bytes the server uses to store that string. If it is multiplied by 3, it means that the collation of your string on the server-side uses 3 bytes per character.

@dougwilson
Copy link
Member

An example is any "utf8" collation will cause MySQL to use 3 bytes per character for storage.

@webjoel
Copy link
Author

webjoel commented Apr 25, 2014

ok. ;)

dveeden pushed a commit to dveeden/mysql that referenced this issue Jan 31, 2023
@julienschmidt
Fix empty SHA2 password handling (mysqljs#800)
ceae19c 
* Fix empty SHA2 password handling

Fixes mysqljs#799

* add empty password test

* fix auth switch
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
question
Milestone
No milestone
Development

No branches or pull requests
2 participants
@dougwilson @webjoel