Mickautsch, Alfred wrote:
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
As no one else seems to have replied to you, if you can send a schema
and working Perl script using DBD::ODBC that demonstrates the problem
I'll take a look.
Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
