Describe the bug
phpmyadmin result:
CREATE TABLE `test` (
`IP` binary(16) NOT NULL DEFAULT x AS `00000000000000000000000000000000`,
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
mysqldump result:
CREATE TABLE `test` (
`IP` binary(16) NOT NULL DEFAULT x'00000000000000000000000000000000'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
How to Reproduce
- Export a table with a binary(16) field with a default value
- Import the result file
Expected behavior
A correctly formatted default value
Screenshots
No response
Operating System
Linux
Web Server
apache/2.4.63-1
Database Server
MariaDB
Database version
11.8.1-MariaDB-deb12-log
PHP version
8.2.27-1
phpMyAdmin version
5.2.2
browser
Firefox 137.0.2 (64-bit)
Additional context
No response
Describe the bug
phpmyadmin result:
mysqldump result:
How to Reproduce
Expected behavior
A correctly formatted default value
Screenshots
No response
Operating System
Linux
Web Server
apache/2.4.63-1
Database Server
MariaDB
Database version
11.8.1-MariaDB-deb12-log
PHP version
8.2.27-1
phpMyAdmin version
5.2.2
browser
Firefox 137.0.2 (64-bit)
Additional context
No response