List:General Discussion« Previous MessageNext Message »
From:Sid Young Date:June 24 1999 10:19pm
Subject:RE: Question: How to keep leading zero's
View as plain text  
Convert to a string and concatenate the number to a 0 if the size is less
required!

my $0.02 worth

Sid

-----Original Message-----
From: Technische Dienst [mailto:td@stripped]
Sent: Friday, 25 June 1999 1:08
To: mysql@stripped
Subject: Question: How to keep leading zero's


Hey there,

how would I keep a leading zero? If I fill an int(5) with 03025 it'll
truncate? (or is that just for behind the comma?) the 0 off. Since I wanna
use this as primary key and it is to indicate or article numbers, which are
always 5 numbers, I'd like to keep the 0 in although it's insignificant.

Thanks for your  time,

Ferry van Steen
Thread
Question: How to keep leading zero'sTechnische Dienst24 Jun
  • Re: Question: How to keep leading zero'sPaul DuBois24 Jun
RE: Question: How to keep leading zero'sSid Young25 Jun