Losing text beyond 255 characters

Hello everyone.  I am new to the mailing list and new to FreeTDS.  I am hoping someone here can help me with this problem because we don't have any FreeTDS experts in-house.

The problem:  Recently, we upgraded our database proxy servers from linux32 platform to lnx86_64 platform.  During this upgrade, we also upgraded the OS from SLES 10 to SLES 11.  After this upgrade, we suffered from a variety of data issues.  Database server = Microsoft SQL Server 2005 SP2.

All issues except this data loss issue were resolved by making the databases and schema ANSI compliant, and by casting UNIQUEIDENTIFIER data types to varchar.  The latest issue that I have been unable to resolve is the loss of data from TEXT data type fields.  Our freetds.conf info is below:

[global]
        # TDS protocol version
;       tds version = 4.2

        # Whether to write a TDSDUMP file for diagnostic purposes
        # (setting this to /tmp is insecure on a multi-user system)
;       dump file = /tmp/freetds.log
;       debug flags = 0xffff

        # Command and connection timeouts
;       timeout = 10
;       connect timeout = 10

        # If you get out-of-memory errors, it may mean that your client
        # is trying to allocate a huge buffer for a TEXT field.
        # Try setting 'text size' to a more reasonable limit
        text size = 64512
        client charset = UTF-8

[server1]
        host = IP address
        port = 1433
        tds version = 8.0

[server2]
        host = IP Address
        port = 1433
        tds version = 8.0

The proxies that we are using that are SLES 10 on linux32 are not suffering from this problem.  Rather than down-grading our newer proxies, I'd like to solve this issue if I can.  Everything I have found online has pointed to setting the text size appropriately, but I believe the text size setting here is ample.  Also, as I mentioned, our linux32 boxes are getting the data back intact, without the truncation.  If you have any suggestions on how I might fix this problem, I would really appreciate.  If I have not provided enough information, please let me know.  Thank you.

Cathy DePaolo


This email and any attachments are intended solely for the use of the individual or entity to whom it is addressed and may be confidential and/or privileged.  If you are not one of the named recipients or have received this email in error, (i) you should not read, disclose, or copy it, (ii) please notify sender of your receipt by reply email and delete this email and all attachments, (iii) Dassault Systemes does not accept or assume any liability or responsibility for any use of or reliance on this email.For other languages, go to http://www.3ds.com/terms/email-disclaimer.