OK so if you use Sybase regularly you probably already know this but I'm more an Oracle man myself and this had me banging my head on my desk.

My situation was that I needed to extract a list of items from NIS and a similar list from a database using DBI::Sybase. Then I needed to produce a list of items present in the first and not in the second and visa versa.

I found several solutions and using test data defined in the program they all worked but real data didn't. Writing data out to file and looking at the items showed common data in both. i.e. There should be some matches but the program didn't see them.

Then I remembered something about zero byte string termination and Sybase so added the following to the processing from DBI::Sybase and behold it works. 

$item =~ s/\0//msx;

[download]
Just thought I'd bring this up since someone (probably me) will need to know about this in the future.

For those interested the database is actually Netcool so it's not really Sybase but it is really.

In reply to Zero byte string termination from DBI::Sybase by tweetiepooh

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.