- Original Message - From: Kralidis,Tom [Burlington]
[EMAIL PROTECTED]
To: Keith Spiller [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Thursday, August 21, 2008 8:28 PM
Subject: RE: Zip Codes with Leading Zeros
Keith (I'm not very familiar with phpMyAdmin): what is the
underlying datatype
Message - From: Kralidis,Tom [Burlington] [EMAIL PROTECTED]
To: Keith Spiller [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Thursday, August 21, 2008 8:28 PM
Subject: RE: Zip Codes with Leading Zeros
Keith (I'm not very familiar with phpMyAdmin): what is the
underlying datatype of your
Keith Spiller schrieb:
Hi Johnny,
Yeah. Sadly I missed the fact that the zip codes were hacked in our original
Works to MySQL conversion until long after I had imported the data into our
current MySQL table. Now we have to fix the numbers in our MySQL table and
guarantee that we can
-Original Message-
From: Keith Spiller [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2008 10:12 PM
To: mysql@lists.mysql.com
Subject: Zip Codes with Leading Zeros
Hi,
RE: Zip Codes with Leading Zeros
We need to export a MySQL table with a zip code field to Excel. We
currently
-Original Message-
From: Andy Shellam [mailto:[EMAIL PROTECTED]
Sent: Friday, August 22, 2008 4:39 AM
To: mysql@lists.mysql.com
Subject: Re: Zip Codes with Leading Zeros
FYI, we have the same issue with exporting phone numbers from MS SQL.
All phones numbers
in the UK start with zero
Zeros
Hi,
RE: Zip Codes with Leading Zeros
We need to export a MySQL table with a zip code field to Excel. We currently
use PhpMyAdmin to export to CSV or Excel files. We have had problems with zip
codes with leading zeros. The leading zeros are removed so that we are left
with incomplete
, August 21, 2008 8:15 PM
Subject: Re: Zip Codes with Leading Zeros
I think the problem is with Excel. When it opens the CSV, it trys to help
you and automatically sets the field type to Number. You may be able to solve
your problem by selecting that column, selecting format fields and changing
Spiller [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Thursday, August 21, 2008 8:28 PM
Subject: RE: Zip Codes with Leading Zeros
Keith (I'm not very familiar with phpMyAdmin): what is the underlying
datatype of your zip code field?
On the command line, if I use:
mysql select