Varchar column reduces to 255 chars in result set

Database

Varchar column reduces to 255 chars in result set

Hello, lately I've run into problem with reducing varchar length to 255 chars in query.

Defined table column has varchar(5000) type and when I run simple select ('select name from t_name' for example) result set is fine and contains all field length. But when I try to join this table with other and select same column there is reduced to 255 chars column in result set. I tried use this select to insert into new table with column type varchar(5000) but it inserts only 255 chars whatever. How can I solve the problem? Thanks

1 REPLY
Teradata Employee

Re: Varchar column reduces to 255 chars in result set

Does your query include UNION/UNION ALL? Can you share your query?