Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Can "carriage returns" be in a VARCHAR(2000) or LONG?

Can "carriage returns" be in a VARCHAR(2000) or LONG?

From: Sean Dolan <dolans_at_stripe.Colorado.EDU>
Date: 17 Jun 98 02:26:59 GMT
Message-ID: <dolans.898050419@stripe.Colorado.EDU>

        I migrated a large database from MS Access 97 to Oracle 7.3.4 on Windows NT 4.0. The field in Access was a MEMO field and the Oracle field is a LONG type. Some of the records in those MEMO fields contained carriage returns (like two paragraphs seperated with a return). Does that carriage return get stored in Oracle fields as well? Or do i need to do something prior to migration?

Thanks,
Sean Dolan
Sr Systems Engineer Received on Tue Jun 16 1998 - 21:26:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US