Bug #87214 Allow CHAR fields multiple padding options
Submitted: 26 Jul 2017 22:08
Reporter: Bob Terrell Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: Data Types Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any
Tags: char

[26 Jul 2017 22:08] Bob Terrell 
Description:
Say I have a CHAR(10) field. I store the value '123456789'.

Internally, it's stored as '123456789 '.

It would be useful if I could specify at table creation that I wanted it to pad on the left, using the character '0'.

Then I would get '0123456789'.

How to repeat:
Make a char field.