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