freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Column name cut-offs

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

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