[ciapug] MySQL table data - "1" and "01" different values

Ryan O'Rourke ciapug@cialug.org
06 Apr 2004 10:11:34 -0500


Is there some way to enter values such as "1" and "01" into a MySQL
table to have them appear as different values and still be sorted in
numerical order? 
CHAR doesn't work because ordering by that field does not result in
sorting by numerical order, and FLOAT drops the leading zeros.

Thanks.

-- Ryan