RE: Use of the quote / apostrophe in text fields

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 16 Mar 2004 06:58:29 -0500
Message-ID: <A186CBDC8B1D61438BC50F1A77E91F73057C1B4D@xchgbrsm1.corp.espn.pvt>

Thank Larry for the quote delimiter ... not the larry_at_oracle, but larry_at_Perl instead ...

Raj

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. select standard_disclaimer from company_requirements; QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Robson, Peter Sent: Tuesday, March 16, 2004 4:18 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Use of the quote / apostrophe in text fields

Thanks for that, guys -

Yes, been down that route, but it is not strictly germaine to the problem. Nevertheless it is a useful technique which I have applied widely. Things become interesting when you have up to a dozen quotes lined up on either side of your data value, which can happen when the data value is itself a quote (think about it...).

No, the problem here is when a field arrives for processing in an update script, and is thus bounded by a quote at start and finish, but ALSO contains an embedded quote. The parser scans down the line of characters, encounters the second quote, assumes that is the end of the field - and all hell breaks loose.

The answer (thank you Pete Sharman) is in 10g, where one can, so it seems, re-define the text string delimiter. I'm just glad someone in Oracle saw fit to address this particular point.

peter
edinburgh

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Tue Mar 16 2004 - 05:54:57 CST