Skip to Content.
Sympa Menu

freetds - Re: Warning: Sybase: column [X] has unknown data type (104)

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: Warning: Sybase: column [X] has unknown data type (104)
  • Date: 06 Nov 2002 08:45:36 +0100


Il mer, 2002-11-06 alle 00:05, David Clark ha scritto:
> We currently run FreeTDS 0.60 through PHP4.2.3 on Linux (Mandrake 8.1,
> kernel 2.4.3) to connect to a SQLServer 2000 database running on Win2K.
> When we made the upgrade to 0.60 (from 0.53) we noticed that some of our
> queries started generating warning messages like "Warning: Sybase: column
> 1 has unknown data type (104)". This problem doesn't seem to happen in
> version 0.60, if we set the TDS version for the database connection to 4.2
> - however, doing so causes us to lose other features (of the TDS ver 7.0
> and 8.0 connections) that I'd rather not give up, i.e. greater than 255
> character varchar fields.
>

Do you use dblib or ctlib (so you compile with --with-sybase or
--with-sybase-ct)? Best results using ct library

Try to a "SELECT CONVERT(BIT,NULL)" and see the result... give same
warning?

> The warnings only seem to be generated for bit columns, in relatively
> large queries. For instance, the case I'm mentioning occurs when I join
> several tables together and return all the columns from one table (the one
> containing the bit fields) and several fields from the other tables -
> however, when I just do a SELECT * FROM the primary table (again, the one
> with the bit fields) everything seems to work fine.
>
> If it were just that a warning message was being generated, it wouldn't be
> so bad, but in addition no values from the "unknown" columns can be
> retrieved through the MSSQL_FETCH* functions.
>
> Anyone have any suggestions?
>

freddy77





  • Re: Warning: Sybase: column [X] has unknown data type (104), Frediano Ziglio, 11/06/2002

Archive powered by MHonArc 2.6.24.

Top of Page