I recently upgraded my application (ASP w/COM backend) to SQL 2000 (SP1 installed) from SQL 7. The data access layer is ADO calling stored procedures. The problem I am seeing now is string parameters are not being trimmed any more when updating, the line below shows the code:
.Parameters.Append .CreateParameter("ModelNumber", adWChar, adParamInput, 50, m_varModelNumber)
this adds the parameter reserving 50 spaces for it. I pass in something like "MODEL1234" but when it is saved to the database it saves "MODEL1234" + 41 spaces,
keeping the 50 characters. This did not occur in SQL 7. I thought this was an issue with the ANSI_PADDING property but I have tried turning it on and off with no results.
This problem is causing major problems in my application, string comparisons are almost impossible now without manually trim all the values (urrrggggg!)
Any help or comments would be appreciated.