Hi,
I'm using V2.6.5 with .NET 3.5.
I've got a simple query like:
SELECT * FROM MailObject WHERE MailBody like '%123456%'
MailBody is a column of type "Blob SUB_TYPE BINARY".
The query is composed using parameters in the "FbCommand":
using (command = new FbCommand("SELECT * FROM MailObject WHERE
MailBody like @SearchText", connection))
{
FbParameter param = new FbParameter();
param.ParameterName = "@SearchText";
param.Value = "%123456%";
command.Parameters.Add(param);
...
Executing this command results in an "IscException":
arithmetic exception, numeric overflow, or string truncation string right
truncation
at FirebirdSql.Data.Common.DbValue.GetBytes() in X:\Lib.NET\Firebird
ADO.net\NETProvider_2.6.5\source\FirebirdSql\Data\Common\DbValue.cs:Zeile 255.
at
FirebirdSql.Data.Client.Common.XsqldaMarshaler.MarshalManagedToNative(Charset
charset, Descriptor descriptor) in X:\Lib.NET\Firebird
ADO.net\NETProvider_2.6.5\source\FirebirdSql\Data\Client\Common\XsqldaMarshaler.cs:Zeile
118.
at FirebirdSql.Data.Client.Native.FesStatement.Execute() in
X:\Lib.NET\Firebird
ADO.net\NETProvider_2.6.5\source\FirebirdSql\Data\Client\Native\FesStatement.cs:Zeile
355.
Because of the check:
case DbDataType.VarChar:
if (this.Field.Charset.IsOctetsCharset)
{
return (byte[])this.value;
}
else
{
string svalue = this.GetString();
if ((this.Field.Length %
this.Field.Charset.BytesPerCharacter) == 0 &&
svalue.Length > this.Field.CharCount)
{
throw new
IscException(new[] { IscCodes.isc_arith_except, IscCodes.isc_string_truncation
});
}
This only happens when the search string within the "%" is longer than 5 chars.
Any idea how to fix this?
Greetings
Harry
________________________________
----------------------------------------------------
JAM Software GmbH
Geschäftsführer: Joachim Marder
Max-Planck-Str. 22 * 54296 Trier * Germany
Tel: 0651-145 653 -0 * Fax: 0651-145 653 -29
Handelsregister Nr. HRB 4920 (AG Wittlich) http://www.jam-software.de
[Non-text portions of this message have been removed]
