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.

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

Searching in tables should use UTF8MB4, not just utf8, to avoid warnings #19056

Open
leifnel opened this issue Mar 16, 2024 · 0 comments
Open

Comments

@leifnel
Copy link

leifnel commented Mar 16, 2024

Describe the bug

Searching for data in table should use UTF8MB4 instead of utf8

To Reproduce

Click on database name in left column.
Click on 'search' in menu bar
Enter 'test' (or something you expect to find) in "Words or values to search for"
Click 'go'
In the result table, click 'Browse' (if none, go back and search for something else)
At the bottom is shown a number of

' Warning: #3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.'

The query phpmyadmin is using is in this style:
SELECT * FROM mydb_db.wp_postmeta WHERE (CONVERT(meta_id USING utf8) LIKE '%test%' )

All tables are utf8mb4_unicode_ci, as is the default character set.

Expected behavior

No warnings.

Screenshots

Server configuration

  • Operating system: Linux (Don't know, hosted database)
  • Database version: 8.0.36-28
  • phpMyAdmin version: 5.2.1

Client configuration

  • Browser: Chrome
  • Operating system: Windows 11

Additional context

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant