All Forums Database
ancientwall 1 post Joined 02/16
25 Feb 2016
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

Adeel Chaudhry 773 posts Joined 04/08
06 Mar 2016

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

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.