Strange string from MEMO field in FireBird

From: Date: Sat, 13 Dec 2008 19:06:24 +0000
Subject: Strange string from MEMO field in FireBird
Groups: php.db 
Request: Send a blank email to php-db+get-45811@lists.php.net to get a copy of this message
Hi, I new in PHP. I work with FireBird and I have query looks: "select Y.Organizm as Nazwa, count(Y.ID) as LiczbaPrzypadkow, count(Y.Organizm) as DodatnichPrzypadkow, count(distinct Y.Pacjent) as LiczbaPacjentow, count(distinct Y.DodatniPacjent) as DodatnichPacjentow , list(distinct Y.DodatnieZlecenie) as DodatnieZlecenia from SelRaportIdentyfikacji('2008-11-01', '2008-11-30') Y left outer join Materialy M on M.ID = Y.Material left outer join Oddzialy O on O.ID = Y.Oddzial group by 1 order by 3 desc, 1" and the result is something like that: http://img509.imageshack.us/img509/5066/78994034sy1.jpg when I double-click on the MEMO field I get window with ID: http://img300.imageshack.us/img300/623/79032822pi4.jpg it looks that everything is OK. But when I write in php echo $row['DODATNIEZLECENIA'] I got values like: 0x0000000c00000000, 0x0000001900000000, 0x0000001400000000, itp.. var_dump($row) gives: array(8) { ["NAZWA"]=> string(16) "Escherichia coli" ["LICZBAPRZYPADKOW"]=> int(42) ["DODATNICHPRZYPADKOW"]=> int(42) ["LICZBAPACJENTOW"]=> int(41) ["DODATNICHPACJENTOW"]=> int(41) ["DODATNIEZLECENIA"]=> string(18) "0x0000000c00000000" ["NAZWAGRUPY1"]=> string(14) "(nieokreślony)" ["NAZWAGRUPY2"]=> string(14) "(nieokreślony)" } I don't know what I'm doing wrong. Why php didn't write correctly exactly this one field? Any help will be aprrecieated. Kamil Walas. P.S. Sorry for my English.

« previous php.db (#45811) next »