Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LF and CR in Oracle

644653Jul 2 2008 — edited Jul 2 2008

Hi,
I am going to migrate DB from SQL server to Oracle 10g. And aware of the CrLf in data field.
In SQL server, I know that char(10)=LF, char(13)=CR. And we create a view for the data so that it will be ready for HTML.(i.e. replace(data, char(10),<br>) )
I just wonder if this work in Oracle? I am afraid the char(10) only work in MS product.
Many thanks for helping.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2008

Added on Jul 2 2008

#general-database-discussions

3 comments

5,046 views