SQL/database server capabilities

[Steve Teale]

On Tue, 29 Nov 2011 09:01:29 -0800, Unknown W. Brackets wrote:

> Steve,
> 
> The type conversion you talk about (bigint -> double) probably happens
> on 32-bit systems, no?  Some of these things will definitely vary
> depending on the database system.
> 
> I disagree with him on validation (although he's right about
> constraints, speaking of atomicy), as others, but I think that's not
> what you're after.
> 
> You just want to know the types of the result fields, right?  I don't
> know this specifically for ODBC/SQL Server, but it may be worth pointing
> out that MySQL sends everything as strings:
> 
It is sorted now. I was using a version of TDS provided by the Ubuntu 
package management system that turned out to be hopelessly out of date. 
I've built it now from FreeTDS CVS, and it works OK.

MySQL 5 returns data from plain old ExecSQL as strings, but for prepared 
statements it uses a binary format. However I have no problems with type 
determination there.

Thanks for taking the trouble to help.

Steve