I am new to MySQL. When I declare a column as VARCHAR, why does it automatically change to VARBINARY? How should I avoid this?
newly created database" class="img-fluid rounded" style="max-width: 100%; height: auto; margin: 10px 0;" loading="lazy">
Database changed
mysql> CREATE TABLE sync(
-> vlan_id INT NOT NULL,
-> vlan_name VARCHAR(90) NOT NULL,
-> vlan_description VARCHAR(100) NOT NULL,
-> PRIMARY KEY(vlan_id)
-> );

Database changed
mysql> SHOW CREATE TABLE sync;
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| sync | CREATE TABLE sync
(
vlan_id
int(11) NOT NULL,
vlan_name
varbinary(90) NOT NULL,
vlan_description
varbinary(100) NOT NULL,
PRIMARY KEY (vlan_id
)
) ENGINE=InnoDB DEFAULT CHARSET=binary |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql>
Asked by unknown29
(1 rep)
Aug 6, 2019, 03:38 AM
Last activity: Nov 11, 2024, 10:03 PM
Last activity: Nov 11, 2024, 10:03 PM