ID: 15151 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: InterBase related Operating System: Windows PHP Version: 4.1.1 New Comment:
The original fix I posted has its own bug (due to me not VC++) when the number is less than 0 but greater than -1 the negative sign does not appear. This fixes it (and the original problem also): case SQL_INT64: tv64 = (ISC_INT64) *((ISC_INT64 *) data); iv64 = (tv64 / (int) pow(10.0, (double) -scale)); fv64 = (ISC_INT64) abs((int) tv64 % (int) pow(10.0, (double) -scale)); val->type = IS_STRING; if ( tv64 < 0 && iv64 == 0 ) val->value.str.len = sprintf(string_data, "-0"); else val->value.str.len = sprintf(string_data, "%Ld", iv64); val->value.str.len += sprintf(string_data + val->value.str.len, ".%0*Ld", -scale, fv64); val->value.str.val = estrdup(string_data); break; Previous Comments: ------------------------------------------------------------------------ [2002-01-21 13:15:30] [EMAIL PROTECTED] This is also reported as #13807 ------------------------------------------------------------------------ [2002-01-21 13:10:17] [EMAIL PROTECTED] Decimals/Numerics that are stored as 64-bit integers always display as xxx.2. The following should fix the problem: Original code (on or about line 1782): val->value.str.len = sprintf(string_data, "%Ld.%0*Ld", (ISC_INT64) (*((ISC_INT64 *)data) / (int) pow(10.0, (double) -scale)), -scale, (ISC_INT64) abs((int) (*((ISC_INT64 *)data) % (int) pow(10.0, (double) -scale)))); Change to: val->value.str.len = sprintf(string_data, "%Ld", (ISC_INT64) (*((ISC_INT64 *)data) / (int) pow(10.0, (double) -scale))); val->value.str.len += sprintf(string_data + val->value.str.len, ".%0*Ld", -scale, (ISC_INT64) abs((int) (*((ISC_INT64 *)data) % (int) pow(10.0, (double) -scale)))); The problem is with MSVC++. It doesn't seem to like two int64s in the same sprintf statement. I don't yet have all the pieces to compile the extension so I have not fully tested it, but I have duplicated the problem in a test program and verified that the above code fixes the problem in the test program. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=15151&edit=1