Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2003

    Question Unanswered: SQL_LONGVARCHAR only 255 characters in Pervasive SQL 2000i?

    Sorry my poor english..

    I'm have some TEXT type fields in tables of my Pervasive Database (SQL 2000i). These fields do not work with SQL queries, for example with SQL Data Manager in Pervasive Control Center. They don't work either through Pervasive JDBC driver, query is failed.

    I have tried to convert these TEXT type fields like: "SELECT CONVERT(column_name, SQL_LONGVARCHAR)" and then it returns data from these fields but only returns 255 characters of my TEXT fields. Why?
    Last edited by CoooL; 07-30-03 at 06:35.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts