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: Frediano Ziglio <freddyz77 AT tin.it>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Column name cut-offs
  • Date: 09 Oct 2002 10:43:05 +0200


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






Archive powered by MHonArc 2.6.24.

Top of Page