tdsodbc truncates varchar fields to 255 characters
Bug #613238 reported by
Mikhail Veygman
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
freetds (Ubuntu) |
Expired
|
Undecided
|
Unassigned |
Bug Description
Binary package hint: tdsodbc
ODBC connection using libtdsodbc connecting to MS SQL server will truncate varchar fields to 255 characters. Confirmed using RODBC and isql.
ProblemType: Bug
DistroRelease: Ubuntu 10.04
Package: tdsodbc 0.82-6build1
ProcVersionSign
Uname: Linux 2.6.32-23-server x86_64
Architecture: amd64
Date: Tue Aug 3 18:52:58 2010
InstallationMedia: Ubuntu-Server 10.04 LTS "Lucid Lynx" - Release amd64 (20100427)
ProcEnviron:
PATH=(custom, no user)
LANG=en_US.UTF-8
SHELL=/bin/bash
SourcePackage: freetds
To post a comment you must log in.
I think I may have found a problem and it is in the way that the library is built.
By default if TDS version is not specified it will set the TDS version to 5.0. There is a way to reset the version of connection after the login, but there doesn't appear to be any calls to the function that does it.
With this the TDS connection version is set to the default from the build which is 5.0 and hence will set the max_len of the varchar, varbinary, etc fields to 255 vs 8000 for the version of TDS 7+.