Issues related to the varchar field of MySQL

Problems with the varchar field of MySQL
The varchar field in MySQL, why 00555 of records are inserted when 555 is stored in the table! How do you guarantee it must be 00555?

------Solution--------------------
' Varcharfield ' = ' 00555 '

Variables with a value of 00555 note that the integer type is not
------Solution--------------------
' 00555 '
------Solution--------------------
Quotes...
------Solution--------------------
Yes, don't be so assigned:
Insert INTO (Myvarchar) VALUES (00555)
But this:
Insert INTO (Myvarchar) VALUES (' 00555 ')

------Solution--------------------
When you insert data by string, there is no case of what you are saying.
------Solution--------------------
It should be that you are not quoted when inserting, so it is treated as an int.
------Solution--------------------
Agree that's the question

