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?