search

martinrybak / SQLClient

Native Microsoft SQL Server client for iOS
http://objcsharp.wordpress.com/2013/10/15/an-open-source-sql-server-library-for-ios/
MIT License
125 stars 51 forks source link

Cannot retrieve text or varchar over 256 characters #5

Closed nhgrif closed 7 years ago

nhgrif commented 10 years ago

Any time a column would return a text or varchar datatype that is over 256 characters, it instead just returns the first 256 and fires the error:code:severity: method with code 20049, "Data-conversion resulted in overflow."

nhgrif commented 10 years ago

This is happening on SQL Server 2008 R2 as well as SQL Server 2005.

nhgrif commented 10 years ago

After further testing, this issue is only actually happening for text and varchar(max). These will only grab the first 256 characters, where varchar(8000) will grab the first 8000 characters.

martinrybak commented 8 years ago

Please try out the types branch. This issue should be fixed.