freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Varchar(max) limition in freeTDS

From: venkata krishna talluri <venkatakrishnat1 AT gmail.com>
To: freetds AT lists.ibiblio.org
Subject: [freetds] Varchar(max) limition in freeTDS
Date: Wed, 17 Jul 2013 11:42:50 +0530

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

[freetds] Varchar(max) limition in freeTDS, venkata krishna talluri, 07/17/2013