Click here to get back home

DBD::Sybase : How to get rid of the 255-char limit on varchar?

 HomeNewsGroups | Search | About
 comp.lang.perl.misc    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
DBD::Sybase : How to get rid of the 255-char limit on varchar? mnagaraj 05-15-2006
Posted by mnagaraj on May 15, 2006, 5:13 pm
Please log in for more thread options
>>
>> [snip]
>>
>> > if I print "$1\n",
>> > the file prints just fine. But, if I do something like print "$1 after
>> > \n", the whole output is messed up. If I print "before $1\n", nothing
>> > prints at all. If I print "before $1 after\n", only after prints.
>>
>> not really sure, but could be a rogue "\r" in $1,


> There
> is a rogue carriage return (0xd) in the string

> Is there something I can do to deal with this
> situation?


Repair the corrupted file:

perl -p -i -e 'tr/\r//d' bad_file


--
Tad McClellan SGML consulting
tadmc@augustmail.com Perl programming
Fort Worth, Texas

Similar ThreadsPosted
dbd-sybase ppd October 22, 2004, 11:18 am
PAR and Sybase::CTlib on HP-UX February 1, 2007, 12:35 pm
how to install Sybase::DBlib??? August 22, 2004, 12:59 am
install_driver(Sybase) failed: February 15, 2006, 4:52 pm
Sybase connection error July 28, 2006, 9:07 am
how to connect to sybase in perl August 21, 2007, 9:02 am
Sybase DBI Returned data query September 9, 2004, 10:22 am
perl dbi sybase number of columns? December 27, 2006, 5:27 pm
binding parameters (timestamp) with DBD::Sybase April 2, 2008, 4:22 pm
Sybase::CTLib ct_connect problem September 30, 2008, 7:56 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap