[Firebird-net-provider] Problem with LIKE predicate. (parameter overflow)

[stephane <ski...@ho...>]

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.