Retrieve text from Oracle Text

------_=_NextPart_001_01C6F120.BA753643
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

=20

My company have a Oracle9i database ...One of the field (text) in this
database is a text file (VARCHAR2) with a length of 100
characters.....The text inside this field is "carriage return" return.=20

=20

When we retrieve this field (select text from db.text_field), it only
shows the first line. The second and the rest of the line does not show
up. Can I know how to I retrieve all the lines in this field?

=20

Thanks..

=20


------_=_NextPart_001_01C6F120.BA753643--

Re: Retrieve text from Oracle Text

Choy, Wai Yew wrote:

> Hi,
>
>
>
> My company have a Oracle9i database ...One of the field (text) in this
> database is a text file (VARCHAR2) with a length of 100
> characters.....The text inside this field is "carriage return" return.
>
>
>
> When we retrieve this field (select text from db.text_field), it only
> shows the first line. The second and the rest of the line does not show
> up. Can I know how to I retrieve all the lines in this field?
>
>
>
> Thanks..

You probably are retrieving all the lines in the field; if you are then
outputting the contents direct to the browser, the browser will ignore the
newlines - View Source should confirm that this is the case. You should use
nl2br() on the retrieved data before passing it to the browser.



Cheers
--
David Robley

"Buy me something to drink?" said Tom drily.
Today is Setting Orange, the 71st day of Bureaucracy in the YOLD 3172.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php