> -----Ursprüngliche Nachricht----- > Von: Martin Evans [mailto:martin.evans@easysoft.com] > Gesendet: Montag, 29. Januar 2007 17:25 > An: dbi-users@perl.org > Betreff: alfred.mickautsch@schuler-ag.com - Bayesian Filter > detected spam - Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO > for SQL Server > > Martin Evans wrote: > > [...] > > so I'm not sure you are losing the new lines but I am sure > your losing > > half of your back slashes down to Perl. > > > > Martin > > Sorry, forgot to say. The inserted text is 100001 chrs according to > length in Perl and the returned chr length is 97145. I had 1486 lines > containing \\\\ and got 97145 chrs back so that suggests all > I lost was > every \\\\ turned into \\ (i.e. no loss of line feeds). > [...] Sorry for answering so late Martin, but we seem to have a SPAM filter problem here :(. Yes, I put the \\\\ there because of perl (just for this example, in the real perl script I use bind_parameter), expecting to find \\ in the database. But what I get out of the database is one \ and no newline (or CRLF). 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@schuler-ag.com