RE: Oracle Vs Sybase

Why i asked because in one of the assignments we did we had this problem with quotes. We tested for all spl.chrs and had problem with quotes. I wanted to get this one clarified. The first suggestion you gave (regarding db level parameter) is quite useful.

GovindanK

On Wed, 22 Sep 2004 14:36:03 +1000, "Grant Allen" <Grant.Allen_at_towersoft.com.au> said:
> > -----Original Message-----
> > From: GovindanK [mailto:gkatteri_at_fastmail.fm]
> > Sent: Wednesday, 22 September 2004 13:13
> > To: Grant Allen; DGUPTA_at_entergy.com; oracle-l_at_freelists.org
> > Subject: RE: Oracle Vs Sybase
> >
> > > Ciao
> > > Fuzzy
> > > :-)
> > >=20
> >=20
> > Have you tried converting / transporting data from other=20
> > databases which
> > have single / double quotes in them?=20
> >

> 
> Govindan,
> 
> Yes, we provide migration facilities to our clients that allow them to =
> move their data freely between Oracle, Sybase, SQL Server and DB2.  I'd =
> say we've performed a few thousand migrations like these over the years.
> =
>  Once you understand the basic bulk data movement / ETL tools =
> (SQL*Loader, bcp, LOAD), it's easy to programmatically handle things =
> like quotes, ascii control characters, etc.  Definitely a case of effort
> =
> up front paying off later.
> 
> Ciao
> Fuzzy
> :-)
> 
> ----------------------------------
> "Everything you think, do, and say
>  was in the pill you took today."
>  -- Zager and Evans
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l