自己想的一些判断存储长度的sql

create table zhaobsh (t1 date ,t2 TIMESTAMP)

insert into zhaobsh values (CURRENT_DATE,CURRENT_TIMESTAMP)

select LENGTH(hex(t1))/2 ,LENGTH(hex(t2))/2 from zhaobsh

select hex(t1) ,hex(t2) from zhaobsh

select char_length(t2) from zhaobsh

 

create table zhaobsh2 (t1 varchar(100),t2 nvarchar(100))

insert into zhaobsh2 values ('A','中国')

select LENGTH(hex(t1))/2 ,LENGTH(hex(t2))/2 from zhaobsh2

show table status like 'zhaobsh%'

select hex(t1) ,hex(t2) from zhaobsh2

323032302D30392D3130

select * from zhaobsh