[freetds] Varchar(max) limition in freeTDS

[venkata krishna talluri]

Hi All,
We are using freetds 8.0 for exporting data from Sybase to MSSQL Server ,it
is working fine but it is having some limitation for varchar(max).It is
allowing upto 256 characters even if we declare more than 256 characters
also. If we define column with varchar(1000) in sybase ,we are able to
store data into the sybase database but while exporting to MSSQL server ,we
are getting the below exception .

Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server
'10.77.243.188': [FreeTDS][SQL Server]Invalid string or buffer length;
nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server
'10.77.243.188': [FreeTDS][SQL Server]Invalid string or buffer length
at
org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:121)
at
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:322)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- Cause: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server
'10.77.243.188': [FreeTDS][SQL Server]Invalid string or buffer length
Caused by: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Server
'10.77.243.188': [FreeTDS][SQL Server]Invalid string or buffer length

Could you please let me know ,Do we have any option for varchar(max) in
freeTDS?
Thanks in advance


Thanks
Venkata krishna