in reply to Re: Typeless bind fails for certain large numbers with MySQL decimal
in thread Typeless bind fails for certain large numbers with MySQL decimal

Howdy!

I'd put it even more strongly. If the data is a string of digits with no numeric significance, then it isn't numeric data, but character data. Further, if there are values with leading zeros (such as ZIP codes), you have to store it as character data or else jump through extra hoops to reapply the leading zeros. Character data won't give you that problem.

yours,
Michael
  • Comment on Re^2: Typeless bind fails for certain large numbers with MySQL decimal