Wide character in print at check_cert.pl line 18.
来源:互联网 发布:js给span标签赋值 编辑:程序博客网 时间:2024/05/19 20:19
[oracle@yyjk md]$ cat check_cert.pl use DBI; use Encode;no utf8;my $dbName = 'tlyy'; my $dbUser = 'tlcbuser'; my $dbUserPass = 'tlcbuser'; my $dbh = DBI->connect("dbi:Oracle:$dbName", $dbUser, $dbUserPass) or die "can't connect to database " ;my $hostSql = qq{select trim(a.name),to_char(a.expired_date),round( expired_date - sysdate) as vardate from tlcb_cert_device a};my ($a,$b,$c);my $selStmt = $dbh->prepare($hostSql); $selStmt->bind_columns(undef, \$a, \$b, \$c); $selStmt->execute(); while( $selStmt->fetch() ){ if ($c < 30){ my $hint='证书到期日期还有'; $hint=decode_utf8($hint); #$a=decode_utf8("$a"); print "$a"."---"."$b"."---"."$hint"."$c"."\n";;}}; $selStmt->finish; $dbh->disconnect or warn "DB disconnect failed: $DBI::errstr\n";[oracle@yyjk md]$ perl check_cert.pl Wide character in print at check_cert.pl line 18.二代支付证书---15-11月-16---证书到期日期还有-239Wide character in print at check_cert.pl line 18.二代支付证书---15-11月-16---证书到期日期还有-239Wide character in print at check_cert.pl line 18.支付宝证书---06-8月 -17---证书到期日期还有25Wide character in print at check_cert.pl line 18.管理员usbkey证书---10-1月 -17---证书到期日期还有-183Wide character in print at check_cert.pl line 18.分析员usbkey证书---10-1月 -17---证书到期日期还有-183解决办法:use DBI; use Encode;use utf8;binmode(STDIN, ':encoding(utf8)');binmode(STDOUT, ':encoding(utf8)');binmode(STDERR, ':encoding(utf8)');my $dbName = 'tlyy'; my $dbUser = 'tlcbuser'; my $dbUserPass = 'tlcbuser'; my $dbh = DBI->connect("dbi:Oracle:$dbName", $dbUser, $dbUserPass) or die "can't connect to database " ;my $hostSql = qq{select trim(a.name),to_char(a.expired_date),round( expired_date - sysdate) as vardate from tlcb_cert_device a};my ($a,$b,$c);my $selStmt = $dbh->prepare($hostSql); $selStmt->bind_columns(undef, \$a, \$b, \$c); $selStmt->execute(); while( $selStmt->fetch() ){ if ($c < 30){ my $hint='证书到期日期还有'; #$hint=decode_utf8($hint); #$a=encode('utf8',"$a"); print "$a"."---"."$b"."---"."$hint"."$c"."\n";;}}; $selStmt->finish; $dbh->disconnect or warn "DB disconnect failed: $DBI::errstr\n";[oracle@yyjk md]$ perl check_cert.pl 二代支付证书---15-11月-16---证书到期日期还有-239二代支付证书---15-11月-16---证书到期日期还有-239支付宝证书---06-8月 -17---证书到期日期还有25管理员usbkey证书---10-1月 -17---证书到期日期还有-183分析员usbkey证书---10-1月 -17---证书到期日期还有-183
阅读全文
0 0
- Wide character in print at check_cert.pl line 18.
- Wide character in print at hcp.pl line 21.
- 为什么出现Wide character in print at a14.pl line 41
- perl unload utf-8 oracle Wide character in print at unload_oracle.pl line 105.
- Wide character in print at ../lib/MonWalkProc.pm line 569.
- [perl]Wide character in print
- Perl Wide character in print问题解决
- Wide character in print 报错
- [perl]解决Wide character in print报错
- 【 Perl 】三种方式解决” Wide character in print “
- use utf8 gives me 'Wide character in print'
- Use of uninitialized value in concatenation (.) or string at test.pl line 232
- usUselesse of addition (+) in void context at ./16.pl line 7.
- Print character
- Illegal character in authority at index 18:
- Change system wide character set
- Extractions from Wikipedia "Wide Character"
- Wrap persistent words count one line in print program
- Python 是如何找模块的呢?
- 上传文件-java.lang.NoSuchFieldException: resourceEntries
- java.lang.IllegalStateException: Optional int parameter 'pageSize' is present but cannot be translat
- C语言选择排序
- HTML中     &thinsp等空白空格的区别
- Wide character in print at check_cert.pl line 18.
- 关于感知学习模型机中空间任一点到超平面的距离公式的推导过程
- Java配置问题一:has value '1.8', but '1.7' is required.
- 启动Producer报错kafka Failed to send messages after 3 tries
- int与宽字符的转化
- 主观和客观
- Qt数据加密类QCryptographicHash实现32位或16位加密
- Java集合:ArrayList、LinkedList
- Win10下Visual Studio 2015编译报“无法注册程序集***dll- 拒绝访问。请确保您正在以管理员身份运行应用程序。对注册表项”***“的访问被拒绝。”问题解决