瀚高数据库:
highgo=# select version();
version------------------------------------
HighGo Database 3.1.4 Linux 64-bit
(1 row)
highgo=# create table b (ZP blob);
CREATE TABLE
highgo=# create table c (ZP bytea);
CREATE TABLE
highgo=#
highgo=# drop table c;
DROP TABLE
highgo=# drop table b;
DROP TABLE
highgo=# create table b (ZP clob);
CREATE TABLE
highgo=# drop table b;
DROP TABLE
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
PostgreSQL数据库中没有此种数据类型:
postgres9.6@[local]:5432 postgres# select version();
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 9.6.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit
(1 row)
Time: 17.132 ms
postgres9.6@[local]:5432 postgres# create table b (ZP blob);
ERROR: type "blob" does not exist
LINE 1: create table b (ZP blob);
^
Time: 2.140 ms
postgres9.6@[local]:5432 postgres# create table b (ZP clob);
ERROR: type "clob" does not exist
LINE 1: create table b (ZP clob);
^
Time: 2.188 ms
postgres9.6@[local]:5432 postgres#
postgres9.6@[local]:5432 postgres# create table b (ZP bytea);
CREATE TABLE
Time: 48.017 ms