develooper Front page | perl.dbi.users | Postings from January 2007

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

From:
Mickautsch, Alfred
Date:
January 30, 2007 01:03
Subject:
AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
Message ID:
D21001870E3EBD40998F656BFE0EE04DB5ABB8@pandora.schuler-ag.com
> -----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




nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About