CoooL
07-30-03, 05:43
| 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? |