[go: nahoru, domu]
Skip to content
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

Support MySql 8.0.1 dmr version and new Character Set default. #13216

Closed
lazzaronetu opened this issue Apr 25, 2017 · 4 comments
Closed

Support MySql 8.0.1 dmr version and new Character Set default. #13216

lazzaronetu opened this issue Apr 25, 2017 · 4 comments
Assignees
@nijel
Labels
enhancement A feature request for improving phpMyAdmin
Milestone
4.7.1

Comments

@lazzaronetu
Copy link
lazzaronetu commented Apr 25, 2017 •
edited
Loading

Steps to reproduce

  1. login

Expected behaviour

Login OK

Actual behaviour

Login fail if a Mysql 8.0.1 configuration use new default character set "utf8mb4" and new default collaction set "utf8mb4_0900_ai_ci", because this collaction aren't recognized by PhpMyAdmin 4.7.0.
For login successful is needed to set old other character set and collaction database.
Attach an image

Server configuration

Operating system: Windows Server 2008 R2

Web server: IIS 7.5

Database: Mysql 8.0.1

PHP version: 7.0.11

phpMyAdmin version: 4.7.0

Client configuration

Browser: Edge, Internet Explorer, Firefox, Chrome

Operating system: Windows 10 Pro Build 16179

immagine
@nijel nijel self-assigned this Apr 28, 2017
@nijel nijel added Bug A problem or regression with an existing feature enhancement A feature request for improving phpMyAdmin and removed Bug A problem or regression with an existing feature labels Apr 28, 2017
@nijel
Copy link
Contributor
nijel commented Apr 28, 2017

Argh, this is another example of MySQL inconsistency in charsets naming.

How UCA version is identified:

  • utf8mb4_0900_ai_ci is based on UCA 9.0.0 weight keys
  • utf8mb4_unicode_520_ci is based on UCA 5.2.0 weight keys
  • utf8mb4_unicode_ci (with no version named) is based on UCA 4.0.0 weight keys

How language is identified:

  • utf8mb4_tr_0900_ai_ci
  • utf8mb4_turkish_ci

See also http://ocelot.ca/blog/blog/2016/09/29/the-first-development-milestone-for-mysql-8-0/.

@nijel nijel mentioned this issue Apr 28, 2017
Merged
4 tasks
@lazzaronetu
Copy link
Author

collation name are recognized but login not work !
senza titolo

@ibennetch
Copy link
Member

In the pull request that may fix this, #13224, there is discussion about which branch this should target.

@nijel
Copy link
Contributor
nijel commented May 4, 2017

Well this one is PHP bug, see https://bugs.php.net/bug.php?id=74461, should be fixed in (upcoming) PHP 7.1.5 and 7.0.19.

@nijel nijel added this to the 4.7.1 milestone May 4, 2017
nijel added a commit that referenced this issue May 4, 2017
@nijel
Changelog entries for #13216 and #13218
436b682 
Signed-off-by: Michal Čihař <michal@cihar.com>
@nijel nijel closed this as completed in 031d379 May 4, 2017
@github-actions github-actions bot locked as resolved and limited conversation to collaborators Jun 22, 2020
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@nijel nijel

Labels
enhancement A feature request for improving phpMyAdmin
Projects
None yet
Milestone
4.7.1
Development

No branches or pull requests
3 participants
@nijel @ibennetch @lazzaronetu