freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Column name cut-offs

From: Stefan Sonnenberg-Carstens <s.sonnenberg AT coolspot.de>
To: TDS Development Group <freetds AT franklin.oit.unc.edu>
Subject: Re: Column name cut-offs
Date: 09 Oct 2002 11:05:11 +0200

We use MS SQL Server 2000 SP2.
freetds-0.60 is configured with --with-tdsver=7.0

Am Mit, 2002-10-09 um 10.43 schrieb Frediano Ziglio:
> Il mer, 2002-10-09 alle 10:18, Stefan Sonnenberg-Carstens ha scritto:
> > Hi list,
> > we recently discovered, that column names longer than 32 chars are
> > stripped down to 32, and thus result in errors in further queries,
> > related to such columns.
> > We were able to bypass the problem by a select very_long_column_name as
> > short_name, but I'd like to know if this is a bug, or a feature ?
> >
> > Thx in advance,
> > Stefan Sonnenberg-Carstens
> >
>
> ???
>
> Da tsql
>
> 1> select 'a' as
> questoeunacolonnaconunnomemoltolungosperodovrebberitornaretuttoilnome
> 2> go
> questoeunacolonnaconunnomemoltolungosperodovrebberitornaretuttoilnome
> a
> 1>
>
> What db do you use?
> Sybase should have a 30 limit while mssql not (from 7).
> You have to use tds protocol 7...
>
> freddy77
>
>
>
> ---
> You are currently subscribed to freetds as: [s.carstens AT coolspot.de]
> To unsubscribe, forward this message to $subst('Email.Unsub')
>

Column name cut-offs, Stefan Sonnenberg-Carstens, 10/09/2002
- <Possible follow-up(s)>
- Re: Column name cut-offs, Frediano Ziglio, 10/09/2002
- Re: Column name cut-offs, Bill Thompson, 10/09/2002
- Re: Column name cut-offs, Stefan Sonnenberg-Carstens, 10/09/2002
- Re: Column name cut-offs, Thompson, Bill D (London), 10/09/2002