cancel
Showing results for 
Search instead for 
Did you mean: 

String truncation in iAnywhere.Data.SQLAnywhere v16

Former Member
3,036

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

Former Member
0 Kudos

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

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

MCMartin
Participant

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.

Accepted Solutions (1)

Accepted Solutions (1)

jeff_albion
Product and Topic Expert
Product and Topic Expert

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.

Answers (0)