more useful options | |
PerlMonks |
Zero byte string termination from DBI::Sybaseby tweetiepooh (Hermit) |
on Oct 09, 2008 at 16:41 UTC ( [id://716256]=perlmeditation: print w/replies, xml ) | Need Help?? |
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. 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.
Back to
Meditations
|
|