freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>
- To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
- Subject: Re: Column name cut-offs
- Date: Wed, 9 Oct 2002 10:07:09 +0100
then what have you got on top of FreeTDS, e.g. PHP ?
> -----Original Message-----
> From: Stefan Sonnenberg-Carstens [SMTP:s.sonnenberg AT coolspot.de]
> Sent: Wednesday, October 09, 2002 10:05 AM
> To: TDS Development Group
> Subject: [freetds] Re: Column name cut-offs
>
> 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')
> >
>
>
>
>
> ---
> You are currently subscribed to freetds as: [thompbil AT exchange.uk.ml.com]
> 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
Archive powered by MHonArc 2.6.24.