On July 28, 2007, PaulCheung wrote:

 When I set the table up I set the LICENCE to INT(8). When populating this
 field I was expecting any number larger than 8 digits to be truncated and
 any number less than 8 digits to be padded out with zeros, in both cases
 > this is not happening.


Randomize a number, convert it to a string, pad and truncate as you want and use a string and not int.

Cheers,

tedd


--
-------
http://sperling.com  http://ancientstones.com  http://earthstones.com
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com

Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php

Reply via email to