Unanswered: how to disable automatic trimming of sp_OAMethod parameters
I need some help related to a trimming problem.
We use an encryption COM object, which is called through the sp_OAMethod.
When passing parameters (crypted values) to this method, it seems the values are trimmed (RTrim at least). As some crypted values end with blank space caracters, trimming them results in changing the crypted value, and so changing also the uncrypted value that is returned.
We tried many things to solve the problem but still can't avoid the trim to occur. I saw in the SQL help some info about SQL server 'Properties' but don't know much.
Our data cells where the crypted values are stored are varchar(255) and I guess the trim is related to this varchar datatype.
If you know a way to disable the trim that seem to be automatic, please answer...