Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
gusschlaien opened this issue Feb 2, 2022 · 1 comment

Comments

@gusschlaien
Copy link

gusschlaien commented Feb 2, 2022

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 gusschlaien changed the title Cannot insert values longer that 16834 chars in SP for type TEXT Cannot insert values longer that 16384 chars in SP for type TEXT Feb 2, 2022
@gusschlaien gusschlaien changed the title Cannot insert values longer that 16384 chars in SP for type TEXT Cannot insert values larger than 16384 chars in SP for type TEXT Feb 2, 2022
@gusschlaien gusschlaien changed the title Cannot insert values larger than 16384 chars in SP for type TEXT Cannot insert values larger than 16384 chars in AseCommand for type TEXT Feb 2, 2022
@Ju42
Copy link

Ju42 commented Dec 5, 2023

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 ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants