Skip to Content.
Sympa Menu

freetds - [freetds] Varchar(max) limition in freeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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

Archive powered by MHonArc 2.6.24.

Top of Page