我在
MySQL中有一个包含撇号(‘)和省略号(…)的值:
$/bin/echo "select alias from url_alias where source = 'node/12024'" | \ MysqL --skip-column-names -D cat36ia_d7prod
输出:
forum/technical-discussion/nagging-questions-i’ve-been-too-embarrassed-ask…
当我使用Perl DBI和DBD :: MysqL检索值时,该值已更改:
$perl -MDBI -MDBD::MysqL -e '$dbh=DBI->connect( "DBI:MysqL:database=my_db",nick ); $v=$dbh->selectrow_array(qq|select alias from url_alias where source = "'node/12024'"|); print "$v\n";'
输出:
forum/technical-discussion/nagging-questions-i?ve-been-too-embarrassed-ask?
为什么Perl这样做?我可以覆盖它吗?