Trimming zeros on insert query

Question

MySQL

Trim zeros on insert query
"INSERT INTO `plug_cat_vals` (`write_id`, `code`, `attr`, `value`) VALUES (%s, '00000000771' %s, '')"
00000000771 -> 771
varchar fields remain 24
must be left with zeros

Answer 1

Perhaps it makes sense to convert the column to int with the ZEROFILL parameter to automatically fill with zeros.
If it is important with varchar and you really have varchar and you are passing a string, then it is highly likely that conversion to int takes place, and most likely somewhere in the model layer.

Answer 2

1. The request in the example is not working at all.
2. Are there no zeros when selecting in scripts, or does it cut right when pasting?

Answer 3

when inserting, here is the complete one:
$this->db->Run("INSERT INTO `plug_cat_vals` (`write_id`, `code`, `attr`, `value`) VALUES (%s, '".(string)$ itemCode."' %s, '')", array( $item['id'], 17) );