Front page | perl.dbi.users |
Postings from January 2007
> -----Ursprüngliche Nachricht----- > Von: Martin Evans [mailto:martin.evans@easysoft.com] > Gesendet: Dienstag, 30. Januar 2007 12:40 > An: dbi-users@perl.org > Betreff: Re: AW: AW: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for > SQL Server [...] > I insert 24 chars (16 \ and 8 line feeds) and I get back 24 chrs. > > I am unsure why the code does not insert CR\LF as I am 100% sure the > file itself contains CR\LF. > > I have tried with ntext, text and char fields - no difference. > > I have run it through a tds spy and can see the line feeds > going through > fine in both directions. [...] Yes, it is a weird problem. There seems to be a byte count limit under which this effect does not occur. It happens with my text example of 102858 bytes. With a text of 569 bytes it does not seem to happen. It is very confusing. Thank you for your efforts. 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