[freetds] unixodbc and character identifier limits?

Lukasz Szybalski szybalski at gmail.com
Mon Apr 7 15:46:59 EDT 2008


On Thu, Apr 3, 2008 at 11:00 AM, James K. Lowden <jklowden at freetds.org> wrote:
>
> Lukasz Szybalski wrote:
>  > On Thu, Apr 3, 2008 at 10:33 AM, James K. Lowden <jklowden at freetds.org>
>  > wrote:
>  > > Lukasz Szybalski wrote:
>  > >  > I came across a 30 character
>  > >  >  identifier limit. In results I wasn't able to query my records
>  > >  >  unless
>  > >  > I have changed the identifier name to something under 30 char.
>  > >
>  > >  It sounds like you're using TDS 4.2 or a Sybase server.
>  >
>  > lucas at debianlaptop:~$ apt-cache policy tdsodbc
>  > tdsodbc:
>  >   Installed: 0.63-3.2
>  >
>  > and I am using sqlserver 2000.
>
>  Yes.  I wasn't referring to the FreeTDS release.  I was referring to the
>  version of the TDS protocol you're using.  It's controlled by the
>  configure script, the "tds version" setting in freetds.conf and the TDSVER
>  environment variable (later overriding earlier).  See the UG for details.
>
>
>  You can determine the version used by a session by looking at a TDSDUMP
>  log.  0.63 is very old, so I don't remember anymore whether the log
>  announces the protocol version.  But if you look at the messages and
>  metadata returned by a server, you'll see they're encoded one of two ways:
>
>  1.  ASCII, TDS 4.2
>  2.  16-bit UCS-2 Unicode, TDS 7.0+
>

What version should I change it to? Right now it has:

[global]
        # TDS protocol version
    tds version = 4.2

Lucas



More information about the FreeTDS mailing list