Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I've just upgraded to SQL Anywhere v16 using ADO.NET. Now, when loading a set of records with a long nvarchar column in, some of the strings are truncated to 65535 in length when retrieved in my .NET app. This is a definite bug in the iAnywhere.Data.SQLAnywhere DLL because if I revert to using v12, this problem goes away.

To reproduce, just create a table with a long nvarchar column. Populate some rows (at least 6) with data longer than 65535. Then, using ADO.NET, use an SACommand and SADataReader to retrieve the long varchar column and inspect the length of each.

Thanks Simon

asked 10 May '13, 11:29

Simon%20Smith's gravatar image

Simon Smith
121338
accept rate: 0%

edited 05 Jul '13, 12:57

Mark%20Culp's gravatar image

Mark Culp
24.9k10141297

This sounds similar to the issues reported in this question... http://sqlanywhere-forum.sap.com/questions/16506/string-truncation-bug-in-ianywheredatasqlanywherev40dll

Could someone tell me if this is the official channel for reporting issues with Sybase?

(13 May '13, 07:27) Simon Smith
Replies hidden
2

You have different options, this forum is read by sybase persons and they might take your observation to fix a bug. Or you can use http://case-express.sybase.com/ to submit a bug, if you are not interested in a guaranteed response time, otherwise you can check http://www.sybase.com/support/aboutsupport/guide for the proper way to contact technical support.

(13 May '13, 10:03) 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.8k171175
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

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:

×261
×43
×39

question asked: 10 May '13, 11:29

question was seen: 2,620 times

last updated: 16 Jul '13, 14:50