Long Varchar Field Driving Me Batty in C#!
Posted on 2006-04-17
I’m trying to retrieve a Long Varchar column from a Sybase Adaptive Server Anywhere 9 database in a C# client application using the .NET OleDB libraries.
I’ve tried both OleDBDataReader and OleDBDataAdapter. I don’t get an error when executing the query, but when attempting to retrieve the Long Varchar field, I get a length of zero from the DB using OleDBDataReader.GetChars, and when attempting to cast into a string, I end up with the empty string.
If I shorten the data in the field to 20 or 30 characters, it works. But at some threshold, the data is too big and I can’t retrieve the data. The data I’m trying to retrieve is around 10,000 characters.