SQL/database server capabilities

[Unknown W. Brackets]

Steve,

Ah, yes, I totally forgot that prepared statements used a better format.

-[Unknown]


On 11/29/2011 9:42 AM, Steve Teale wrote:
> 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