Mags Phangisa wrote:
> I have changed the field to a text blob but the hard return is still not
> being recognised. I use ibase_blob_echo($rec->FLDNM) to display the data.
> What could I be doing wrong?
ibase_blob_echo() means you're probably using PHP, so you're probably
using HTML as output. HTML does not render newline characters by
default. You have two options:
1. wrap the output in <pre>....</pre> tags
2. use nl2br PHP function. In this case you cannot use ibase_blob_echo
as you need to pre-fetch the blob data into string. To extend the BLOB
example from PHP manual, you would use something like this:
<?php
$result = ibase_query("SELECT blob_value FROM table");
$data = ibase_fetch_object($result);
$blob_data = ibase_blob_info($data->BLOB_VALUE);
$blob_hndl = ibase_blob_open($data->BLOB_VALUE);
echo nl2br(ibase_blob_get($blob_hndl, $blob_data[0]));
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
