Varchar(max) limition in freeTDS

venkata krishna talluri <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CA+nnEYpg4OB8RAAOhN4iWj__=H8uhj-YL6ZYKmt=72t-Nq9bRw@mail.gmail.com>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.