Microsoft ODBC bug

[Dom Latter]

On 21/06/2019 15:29, Herwin Weststrate wrote:
> On 21-06-19 16:27, Dom Latter wrote:
>>>      Maybe if it was 256, or 2^16 or 2^31. But a 5-digit number?  WTF.
>>
>> Indeed.  But four digits = four 8 byte characters = 32 bits.
>>
>> And five makes 40 bits.  Hence by some amazingly flawed logic,
>> 9999 is fine, and 10000 is  "too big to go in an int".
>>
>> And that is the only plausible explanation I can think of.
>>
>> As I said, I would love to see the source code behind this...
> 
> Out of curiosity, does -999 work, and does -1000 fail?

Umm, I don't know, and I have uninstalled the Microsoft driver while I
give iodbc a go - if /when I go back to it I will run that test.