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