Sample Header Ad - 728x90

VARCHAR automatically changes to VARBINARY

0 votes
1 answer
760 views
I am new to MySQL. When I declare a column as VARCHAR, why does it automatically change to VARBINARY? How should I avoid this? <code class=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