We are trying to do "select" from a table has a TEXT data type column.
The "SELECT" is done in a Java program using SYBASE JDBC driver. ( I
created the table through java program and also inserted the data into the
table using Java program).
When we do the "select" through the Java program, we get the error as
SQL Server is now using a multi-byte character set,
and the TEXT character counts have not been re-calculated
using this character set for table 'SCIS_SCHEMATA'.
Use DBCC FIX_TEXT on this table before running the
This table has a column with TEXT data type.
Can someone please give some guidance on this.
Thank you in advance.
Date: Wed, 11 Apr 2001 10:22:11 -0400
Subject: SELECT on a table which has TEXT datatype
Content-Type: text/plain; charset="us-ascii"
Xref: forums-1-dub sybase.public.jconnect30:185
Article PK: 255685