Re: 4 Digit ID with Leading Zeros

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Rahul S. Johari wrote:

Ave,

I'm looking into the ZEROFILL option now. Didn't know about it before but it
looks promising and probably is my solution. I'll get back.

Thanks a ton!

On 12/15/05 10:24 AM, "Jim Moseby" <JMoseby@xxxxxxxxxxxxxxxxx> wrote:

Zerofill in mysql will do it. But, many mysql 'clients' don't 'display' the zeros. As best that I remember, phpMyAdmin does show the zeros, so be careful as what you 'see' might not really be what you 'get'. Seems like there are issues with the viewing of this in Excel as well.. Friggin programs that think they are smarter that people!!!!

Anyway, that'll do the mysql side of it for you.

John Hinton

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux