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.