perl往mysql添加中文出现???,如何解决?

发布网友发布时间：2022-05-07 07:47

共5个回答

懂视网时间：2022-05-07 12:08

mysqlperl测试diffmha

Sat Apr 2 02:25:21 2016 - [info] Checking MHA Node version..
Sat Apr 2 02:25:23 2016 - [error][/usr/lib64/perl5/vendor_perl/MHA/ManagerUtil.pm, ln122] Got error when getting node version. Error:
Sat Apr 2 02:25:23 2016 - [error][/usr/lib64/perl5/vendor_perl/MHA/ManagerUtil.pm, ln123]
Undefined subroutine &MHA::NodeUtil::client_cli_prefix called at /usr/bin/apply_diff_relay_logs line 99.
Sat Apr 2 02:25:23 2016 - [error][/usr/lib64/perl5/vendor_perl/MHA/ManagerUtil.pm, ln150] node version on 192.168.1.101 not found! Is MHA Node package installed ?
at /usr/lib64/perl5/vendor_perl/MHA/MasterMonitor.pm line 374
Sat Apr 2 02:25:23 2016 - [error][/usr/lib64/perl5/vendor_perl/MHA/MasterMonitor.pm, ln424] Error happened on checking configurations. Died at /usr/lib64/perl5/vendor_perl/MHA/ManagerUtil.pm line 151.
Sat Apr 2 02:25:23 2016 - [error][/usr/lib64/perl5/vendor_perl/MHA/MasterMonitor.pm, ln523] Error happened on monitoring servers.
Sat Apr 2 02:25:23 2016 - [info] Got exit code 1 (Not master dead).

MySQL Replication Health is NOT OK!

热心网友时间：2022-05-07 09:16

看看数据库的默认字符集是GB2312吗

如果是的话，那可以告诉你，那不是乱码，只是所用的工具不同造成的

热心网友时间：2022-05-07 10:34

my $gb_packed = pack ('H*', "你好");

my $rows=$dbh->do("INSERT INTO test(test) VALUES($gb_packed)");

###########################

# for retrieval
# my $gb2312 = unpack ('H*', $SELECT);

###########################

热心网友时间：2022-05-07 12:09

有可能是程序文件的编码有问题

热心网友时间：2022-05-07 14:00

你只是把连接编码给改gb2312了，你看看表的字段编码是不是gb2312