Bug #26799 Char and binary types without padding/stripping
Submitted: 2 Mar 2007 16:02 Modified: 10 Oct 2008 12:01
Reporter: Olaf van der Spek (Basic Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Data Types Severity:S4 (Feature request)
Version:* OS:Any (*)
Assigned to: CPU Architecture:Any
Tags: qc

[2 Mar 2007 16:02] Olaf van der Spek 
Description:
Could you add char and binary types that are not padded/stripped?

> When BINARY values are stored, they are right-padded with the pad value to the specified length.

> For VARBINARY, there is no padding on insert and no bytes are stripped on select.

How to repeat:
-
[3 Mar 2007 19:39] Valeriy Kravchuk 
Thank you for a reasonable feature request.
[10 Oct 2008 11:35] Alexander Barkov 
Why don't you use VARCHAR and VARBINARY data types?

They are neither padding nor stripping.
[10 Oct 2008 12:01] Olaf van der Spek 
Because they're variable width instead of fixed width.