> If this is so, IMNSHO it was a wrong decision: > Zip codes are character strings, even though they may (in some / many > countries) consist of digits only. > Use a "char (n)" column for them, with "n" varying by country.
So did I, as in the char(n) however, the import script I wrote, in the language I was using, being pretty lose at times, has a habit of turning strings to ints, so 01 is 1, and that's what gets sent off to the database. It was after I imported 40,000 of these, that I noticed. I did not want to re-parse all those again, as it takes some time, so I just ran the update and all was well. Thanks everyone. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]