Teradata超长数据会截断

1.数据库版本

Teradata 15.10

2.测试案例：

create multiset table test_stg (
col1 varchar(10) CHARACTER SET LATIN not null
);
create multiset table test_pdm(
col1 varchar(5) CHARACTER SET LATIN not null
);
insert into test_stg values('测超长错误');
insert into test_pdm select col1 from  test_stg;

sel * from test_pdm;

 

转载于:https://www.cnblogs.com/badboy200800/p/9863224.html