Binding to CHAR columns - problem?
Greetings All;
My Developers are reporting something that sounds a bit odd, but thought I'd better get a second opinion before crying "Bug!"
Client : Visual Studio 2010, .Net 4.0, Windows 7, x64 (I think)
Database : 11.1.0.7.0 (Linux Redhat)
From a .Net client program, they are issuing SQL queries (actually updates) against CHAR columns using bind variables to supply the query values (like good little Developers), something like this:
My Developers are reporting something that sounds a bit odd, but thought I'd better get a second opinion before crying "Bug!"
Client : Visual Studio 2010, .Net 4.0, Windows 7, x64 (I think)
Database : 11.1.0.7.0 (Linux Redhat)
From a .Net client program, they are issuing SQL queries (actually updates) against CHAR columns using bind variables to supply the query values (like good little Developers), something like this:
update ... where char_field = ?The oddity arises where the char_field involved contains trailing spaces.
- If the parameter value is padded out to the correct length for the field, then all is well and the query works as expected.
0