I appreciate your help Jeff. The pragma you specified does not correct the issue... the warning is still thrown up. I agree with you that it doesn't affect the outcome of the script, however, the scheduler I run all my scripts from returns a failed status when warnings such as these are thrown up.
Thanks for your help. Swb -----Original Message----- From: Jeff Zucker [mailto:[EMAIL PROTECTED] Sent: Thursday, February 05, 2004 3:06 PM To: Bryson, Stewart; dbi-users Subject: Re: can you help Bryson, Stewart wrote: > I'm getting the following error when I use your DBD::AnyData module: > Wide character in print at > /usr/local/lib/perl5/5.8.0/sun4-solaris/IO/Handle.pm > line 439 (#1) > (W utf8) Perl met a wide character (>255) when it wasn't expecting > one. > That's not an error, it's a warning - meaning that it's purely advisory and doesn't necessarily impact the script. It's a warning from Perl, not from DBI or the DBD. > This warning is by default on for I/O (like print) but can be > turned off by no warnings 'utf8'; > In other words, put this at the top of your script to eliminate the display of the warning: no warnings utf8; AFAIK, DBD::AnyData doesn't care whether or not the information is in utf8. > Below is the code I'm executing: > > $ad_dbh->func( > 'lead_detail', > 'DBI', > $orac_dbh, > {sql=>$sql}, > 'ad_import'); > > $ad_dbh->func( > 'lead_detail', > 'CSV', > '/tmp/CustomLeadService_filtered_leads.csv', > 'ad_export'); > > The $orac_dbh is an oracle DBI handle. This module works great, but it > looks like I need to somehow prepare a handle for an extra wide > character. Would you know where in your code to start looking? > I think the "no warnings" statement should fix it, but do let me know if I'm wrong. I'm cc'ing the [EMAIL PROTECTED] listserv in case someone with Unicode tuits has something to add. > Stewart W. Bryson | Database Architect > KnowledgeStorm, Inc. > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > -- Jeff
