Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Our database connections currently use the Microsoft assembly. We discovered the Sybase assembly is more efficient. We tried to replace the Microsoft assembly with Assembly version was SADataReader failed to read large string values properly.

For example, several rows contained over 80000 characters in the string column. However, it only returned 65535 characters. We also had some rows containing over 160000 characters - and those worked fine. We tried to work around the problem using casts, appending spaces within query, etc. However, nothing worked.

The column in question is a "long varchar" column (CLOB). So maybe these column types have issues. We have decided to keep using the Microsoft solution until the bug is addressed.

asked 23 Apr '13, 11:11

zardozwildman's gravatar image

accept rate: 0%

edited 05 Jul '13, 13:00

Mark%20Culp's gravatar image

Mark Culp

Thanks for your report. Unfortunately, it's not clear from your description how you're seeing this behaviour precisely - could you please add the .NET code to your description that you used to retrieve the values? We may be able to help clarify the behaviour if you can provide an example for us.

(23 Apr '13, 21:22) Jeff Albion
Replies hidden

Maybe it is a problem with the encoding of the data in the strings...

(24 Apr '13, 03:53) Martin

UPDATE: This issue is now resolved in CR #742857, in builds,,

I have now been able to reproduce this issue and have opened CR #742857 to address this problem in a future EBF of SQL Anywhere. Thank you for the bug report.

permanent link

answered 08 Jul '13, 10:10

Jeff%20Albion's gravatar image

Jeff Albion
accept rate: 25%

edited 16 Jul '13, 14:50

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 23 Apr '13, 11:11

question was seen: 2,750 times

last updated: 16 Jul '13, 14:50