CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server

Hello,

I have a problem with inserting CLOBS into a SQL Server database.
With the attached scripts, we replicate table data schema between different databases.
These databases are located on different servers running Oracle, DB2 and SQL Server.
We use Activestate perl 5.8.0 on Windows 2000 and XP with DBI 1.52, DBD::Oracle 1.15 for Oracle, DBD::DB2 0.78 for DB2 and DBD::ODBC 1.13 and/or DBD::ADO 2.95 for SQL Server.
Replication between Oracle and DB2 works ok.
There is a difference on the SQL Server databases: all fields that are CLOBs on Oracle and DB2 are NCLOBs on SQL Server.
When inserting data (ASCII data which comes from a Oracle CLOB) into a NCLOB on SQL Server, backslashes at the end of a line seem to be interpreted as escape characters and the backslash and the following newline are removed from the data.
Can somebody tell me what to do, so that the CLOB data is not modified?
If this problem is off topic please point me to the right list. Thank you.

Servus -- Alfred

--
Alfred Mickautsch

Schuler Business Solutions AG
Karl-Berner-Str. 4
D-72285 Pfalzgrafenweiler
tel: +49 (0)74 45 830-184
fax: +49 (0)74 45 830-349
e-mail: alfred.mickautsch@xxxxxxxxxxxxxx

Attachment: dbtabrest.pl
Description: dbtabrest.pl

Attachment: dbtabsave.pl
Description: dbtabsave.pl

Relevant Pages

  • Re: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
    ... I have a problem with inserting CLOBS into a SQL Server database. ... These databases are located on different servers running Oracle, DB2 and SQL Server. ... There is a difference on the SQL Server databases: all fields that are CLOBs on Oracle and DB2 are NCLOBs on SQL Server. ...
    (perl.dbi.users)
  • Re: Open DB using OLE DB
    ... I am using both SQL Server and Oracle. ... tried opening the SQL Server database, I use the SQLOLEDB.1 provider. ...
    (microsoft.public.vb.general.discussion)
  • Re: Analysis Services on top of an Oracle DB
    ... a ms access database or sql server database. ... We have great experience with a DWH in Oracle and OLAP cubes in MS ... >> Oracle DB as it is on top of Microsoft SQL Server? ...
    (microsoft.public.sqlserver.olap)
  • Re: Distributed Transaction
    ... I have one SQL Server database and one oracle database.... ... Under this scenario I would use two separate transactions, one for SQL Server and one for Oracle. ... second operation fails, e.g. Oracle, then you would rollback the SQL Server transaction. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Open DB using OLE DB
    ... I am using both SQL Server and Oracle. ... > tried opening the SQL Server database, ... > Here is my code to open SQL Server database: ...
    (microsoft.public.vb.general.discussion)