二进制数据类型
序号 |
MySQL数据库 |
GaussDB数据库 |
差异 |
---|---|---|---|
1 |
BINARY[(M)] |
支持,存在差异 |
|
2 |
VARBINARY(M) |
支持,存在差异 |
|
3 |
TINYBLOB |
支持,存在差异 |
|
4 |
BLOB |
支持,存在差异 |
|
5 |
MEDIUMBLOB |
支持,存在差异 |
|
6 |
LONGBLOB |
支持,存在差异 |
|
7 |
BIT[(M)] |
支持,存在差异 |
|
示例:
-- GaussDB场景 m_db=# create table test(a binary(10)); CREATE TABLE m_db=# insert into test values(0x8000); INSERT 0 1 m_db=# select hex(a) from test; hex ---------------------- 80202020202020202020 (1 row) m_db=# select * from test where hex(a) = 80000000000000000000; a --- (0 rows) m_db=# CREATE TABLE test2(a binary(10)); CREATE TABLE m_db=# INSERT INTO test2 VALUES(0x80008000); INSERT 0 1 m_db=# SELECT hex(a) FROM test2; hex ---------------------- 80202020202020202020 (1 row) -- Mysql场景 mysql> create table test(a binary(10)); Query OK, 0 rows affected (0.01 sec) mysql> insert into test values(0x8000); Query OK, 1 row affected (0.00 sec) mysql> select hex(a) from test; +----------------------+ | hex(a) | +----------------------+ | 80000000000000000000 | +----------------------+ 1 row in set (0.00 sec) mysql> select * from test where hex(a) = 80000000000000000000; +------------+ | a | +------------+ | ▒ | +------------+ 1 row in set (0.00 sec) mysql> CREATE TABLE test2(a binary(10)); Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO test2 VALUES(0x80008000); Query OK, 1 row affected (0.00 sec) mysql> SELECT hex(a) FROM test2; +----------------------+ | hex(a) | +----------------------+ | 80008000000000000000 | +----------------------+ 1 row in set (0.00 sec)