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

32k-cutoff of image data while reading from ASE 15.7/16 #222

Open
akley opened this issue Feb 18, 2022 · 1 comment
Open

32k-cutoff of image data while reading from ASE 15.7/16 #222

akley opened this issue Feb 18, 2022 · 1 comment

Comments

@akley
Copy link

akley commented Feb 18, 2022

I have a strange behavior when reading an image field from DB with your client.

What I have found out:
AseDataReader.GetValue delivers a byte array with a lenght of max 32768 bytes.
AseDataReader.GetBytes call internaly GetValue and deliver the same 32768 bytes.

But the size of the image in the database is 148655 bytes.
I think that the underlying RowResult object holds the wrong amount of bytes in the CurrentRow instance.

It is possible that this could a bug?

Environment

  • .NET Standard 2.0.3
  • AdoNetCore.AseClient nuget package version 0.19.1
  • Sybase ASE 15.7 & 16.0

Best regards
Alex

@mosheb
Copy link

mosheb commented May 3, 2022

seems like standard sybase behavior. For every query prefix your sql with SET TEXTSIZE X
where X is max size you expect from the data. I always use 2000000 which is more or less max size possible

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