DBD-mysql icon indicating copy to clipboard operation
DBD-mysql copied to clipboard

ChopBlanks

Open kuerbis opened this issue 3 years ago • 0 comments
trafficstars

ChopBlanks

this attribute determines whether a fetchrow will chop preceding and trailing blanks off the column values. Chopping blanks does not have impact on the max_length attribute.

If I am not mistaken, only the trailing blanks are chopped.

From the DBI documentation:

ChopBlanks

Type: boolean, inherited

The ChopBlanks attribute can be used to control the trimming of trailing space characters from fixed width character (CHAR) fields. No other field types are affected, even where field values have trailing spaces.

Maybe you could mention that the DBD::mysql ChopBlanks affects also text data types which are not CHAR.

dbdimp.c line 4317 http://www.mysql.org/doc/refman/5.0/en/c-api-datatypes.html => Page Not Found

kuerbis avatar Jul 01 '22 06:07 kuerbis