Sybase 15 text datatype mapping to OleDBType RRS feed

  • Question

  • Can someone please let me know what OleDBType datatype I should map to for Sybase text datatype?

    I am trying to insert a huge string which more than 5000 characters into Sybase 15 database and the underlying column DB type is defined as TEXT. This TEXT datatype is similar to BLOB in Oracle or IMAGE TEXT in Sybase.

    Appreciate a quick response. 


    Monday, January 28, 2013 11:16 AM


  • I would suspect that it depends upon the driver you are using, since the handling of these data types are generally driver or provider specific. Sometimes you can use a simple parameter and other times a method called "chunking" is required.

    Also, for .NET a native Sybase provider would be preferable over OLEDB. 

    Paul ~~~~ Microsoft MVP (Visual Basic)

    • Marked as answer by Alexander Sun Thursday, February 7, 2013 7:02 AM
    Tuesday, January 29, 2013 1:24 PM