[freetds] Varchar(max) limition in freeTDS

venkata krishna talluri venkatakrishnat1 at gmail.com
Wed Jul 17 02:12:50 EDT 2013


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


More information about the FreeTDS mailing list