Hello,
please consider the following query :
SELECT *
FROM Customers
WHERE Name LIKE @param1
And suppose that Customers.Name column datatype is CHAR(4)
-------------------
now, here's the C# code snippet used :
FbCommand fb = conex.CreateCommand();
fb.CommandText = "SELECT * FROM Customers WHERE Name LIKE @param1" ;
fb.Parameters.Add("@param1", "JOHN%");
-------------------
The execution of query fails because it's considered "arithmetic overflow /
string truncation".
"JOHN%" string length is 5, which is bigger than 4 so it's considered wrong...
but the resulting query would be entirely VALID! Same would happend if you use
other combination of wildcards in the LIKE expression, for example "JOH^T" (
"JOH" and not "T").
If someone could give me an hint or a solution to this problem it would be
greatly appreciated because it's critical for my app. This is very serious.
Thanks in advance.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
