PHP MS SQL ID format problem

I'm drawing records into PHP from a legacy MSSQL database built for/by an ASP.net application.

The id's in ASP appear as long strings of numbers but when retrieved by PHP are in a form开发者_运维知识库 like so:

3;Í}±¯I©ûzƒgŸó

---

In PHP 7 and up you now have to "tell" PDO to use the string representation of the GUID when returning it as opposed to the default binary representation.

See: https://github.com/php/php-src/pull/2001

Solution:

     /* $db represent the PDO connection */
     $db->setAttribute(PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER, true);

---

I'm going to wager that the IDs are actually GUIDs -- if so you will want to convert your GUIDs to strings using mssql-guid-string (or if you are using PHP 5.3 or later you will want to use Microsoft's SqlSrv extension, which should convert GUID fields automatically.)

---

Use this function. It retuns cenverted mssql id. Example: G4G3G2G1-G6G5-G8G7-G9G10-G11G12G13G14G15G16

 function convertBinToMSSQLGuid($binguid)
 {
    $unpacked = unpack('Va/v2b/n2c/Nd', $binguid);
    return sprintf('%08X-%04X-%04X-%04X-%04X%08X', $unpacked['a'], $unpacked['b1'], $unpacked['b2'], $unpacked['c1'], $unpacked['c2'], $unpacked['d']);
 }

---

set in connection following attribute PDO::DBLIB_ATTR_STRINGIFY_UNIQUEIDENTIFIER as true

source https://github.com/php/php-src/pull/2001