The client software already could handle the setting ANSI_PADDING = OFF. For this software, having or not having trailing spaces or trailing zeroes does not matter. Code changes are not necessary.

set ansi_padding off

create table t (vc nvarchar(30) null, vb varbinary(30) null);

insert into t values (N'some text ', 0xF4C30000);

select N'*' + vc + N'*', vb from t;

drop table t;

go

set ansi_padding on

create table t (vc nvarchar(30) null, vb varbinary(30) null);

insert into t values (N'some text ', 0xF4C30000);

select N'*' + vc + N'*', vb from t;

drop table t;

go