AdoNetCore.AseClient icon indicating copy to clipboard operation
AdoNetCore.AseClient copied to clipboard

Cannot insert values larger than 16384 chars in AseCommand for type TEXT

Open gusschlaien opened this issue 3 years ago • 1 comments

When I want to write a value longer that 16384 chars setting as a parameter of type TEXT it just throws me an exception. I.e.: DEFINING THE PARAMETER AS

        var parameter = new AseParameter
        {
            ParameterName = paramName,
            //DbType = DbType.String,
            AseDbType = AseDbType.Text,
            Value = paramValue,
        };
        command.Parameters.Add(parameter);

THEN WHEN EXECUTING THE COMMAND I GET EXCEPTION: ▶ | $exception | {"The token datastream length was not correct. This is an internal protocol error.\n"} |

Environment

  • .NET Framework 5.0
  • AdoNetCore.AseClient nuget package version 0.19.2

gusschlaien avatar Feb 02 '22 16:02 gusschlaien

Hello, this behavior seems to be covered by the following test class https://github.com/DataAction/AdoNetCore.AseClient/blob/master/test/AdoNetCore.AseClient.Tests/Integration/Insert/TextTests.cs. Could you please check if those test are working on your side ?

Ju42 avatar Dec 05 '23 10:12 Ju42