Re: 4 Digit ID with Leading Zeros

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

 



Ave,

Yes phpMyAdmin does but I'm sure many other don't. I'll keep this in mind.
Thanks.


On 12/15/05 11:01 AM, "John Hinton" <webmaster@xxxxxxxx> wrote:

> 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

Rahul S. Johari
Coordinator, Internet & Administration
Informed Marketing Services Inc.
251 River Street
Troy, NY 12180

Tel: (518) 266-0909 x154
Fax: (518) 266-0909
Email: rahul@xxxxxxxxxxxxxxxxxxxx
http://www.informed-sources.com

-- 
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