Code: Select all
CREATE TABLE `panel_data_requests` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`packet_data` binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0'
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3238 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
But when I view that table in DBForge I get a create table with extra escaping:
Code: Select all
CREATE TABLE `panel_data_requests` (
id int(11) NOT NULL AUTO_INCREMENT,
packet_data binary(16) NOT NULL DEFAULT '\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0\\0',
...
Obviously that is invalid SQL and it's not possible to create or set a non-ASCII default via DBForge.
Both hex and escaped zeros are valid in that situation:
Code: Select all
ALTER TABLE panel_data_requests
CHANGE COLUMN packet_data packet_data binary(16) NOT NULL DEFAULT 0x00000000000000000000000000000000;
ALTER TABLE panel_data_requests
CHANGE COLUMN packet_data packet_data binary(16) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0';