You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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
The text was updated successfully, but these errors were encountered:
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
Client configuration
Additional context
The text was updated successfully, but these errors were encountered: