Skip to Content.
Sympa Menu

freetds - Re: Column name cut-offs

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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')





Archive powered by MHonArc 2.6.24.

Top of Page