sql server - Calling Stored Proc with CHAR Parameters results in a parameter with a huge value -
i calling stored proc [ms sql] using ef5 .net application
the call ef
return base.executefunction<sp_select_contracts_result>("sp_select_contracts", x, y, z);
in proc parameter defined @para1 char(2)
etc
but in sql profiler caught ef sending following
exec [dbo].[sp_select_contracts_statistics] @x='15 '@y='24 ',@z='2010 '
exactly - huge amount of spaces after actual value.
when change char varchar works correctly:
exec [dbo].[sp_select_contracts_statistics] @x='15','@y='24,@z='2010
'
i work around easily, know missing here.
update: forgot mention in c# values strings. in last call c# before going through ef values correct: x = "15" {string}
etc..
edit2: changing chars varchars worked expected. still prefer know if bug or missing.
Comments
Post a Comment