declare @a table(col varchar(20))
insert into @a select 'aabb'
union all select '你好df'
union all select '你df好'
union all select '你df好'
select * FROM @a WHERE LEN(col)<>DATALENGTH(col)
select LEN(col),DATALENGTH(col) from @a
declare @a table(col varchar(20))
insert into @a select 'aabb'
union all select '你好df'
union all select '你df好'
union all select '你df好'
select * FROM @a WHERE LEN(col)<>DATALENGTH(col)
select LEN(col),DATALENGTH(col) from @a