Our database connections currently use the Microsoft system.data.odbc assembly. We discovered the Sybase assembly is more efficient. We tried to replace the Microsoft assembly with ianywhere.data.SqlAnywhere.v4.0.dll. Assembly version was 11.0.1.29134. 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

zardozwildman
1111
accept rate: 0%

edited 05 Jul '13, 13:00

Mark%20Culp's gravatar image

Mark Culp
22.6k9129265

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 11.0.1.3013, 12.0.1.3937, 16.0.0.1602.


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
10.7k171174
accept rate: 24%

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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×137
×35
×8

question asked: 23 Apr '13, 11:11

question was seen: 902 times

last updated: 16 Jul '13, 14:50