DBD :: mysql：chopblanks

Question

为什么未启用chopblanks，为什么从列值中砍掉毛坯？

use DBI;

my $value = '     string     ';
my $db = 'my_mysql_db';
my $dbh = DBI->connect( "dbi:mysql:db=$db", 'user', '*', {  RaiseError => 1, ChopBlanks => 0 } ) or die DBI->errstr;
my $table = 'test_mysql';
$dbh->do( "CREATE TABLE IF NOT EXISTS $table (col_1 CHAR(64))" );
my $sth = $dbh->prepare( "DELETE FROM $table WHERE col_1 = ?" );
$sth->execute( $value );
$sth = $dbh->prepare( "INSERT INTO $table (col_1) VALUES( ? )" );
$sth->execute( $value );
$sth = $dbh->prepare( "SELECT * FROM $table" );
$sth->execute();
$sth->dump_results; 

---

'     string'
1 rows

Answer 1

我相信这是MySQL的事情，而不是DBI的事情。来自 11.3.2 char and var and var and var and var type ：

当存储char> char值时，将它们正确地填充了指定长度的空间。当检索Char值时，除非启用pad_char_to_full_length SQL模式。