At 5:26 -0700 10/2/04, Stuart Felenstein wrote:
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
Are you trying to store telephone number values with
the intermediate dashes? Such values are not
actually
numbers. You'll need to store them as strings, or
else remove the dashes.
Yes, they made all th
oration
SW Florida's First ISP
- Original Message -
From: "GH" <[EMAIL PROTECTED]>
To: "Stuart Felenstein" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, October 02, 2004 8:09 AM
Subject: Re: Telephone number column not working
One issue
> I have a field "telephone".
> Set to type :int:
> Length: 11
You cannot store a phone-number in an "int".
Use (var)char.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
--
MySQL
--- Paul DuBois <[EMAIL PROTECTED]> wrote:
> Are you trying to store telephone number values with
> the intermediate dashes? Such values are not
> actually
> numbers. You'll need to store them as strings, or
> else remove the dashes.
Yes, they made all the difference.
Set the field type to va
Hi
could it be that the - or a space is upsetting things?
111-111- might be calculated to give -
or if the user enters a space it is no longer an integer
unless you need it to be an integer, telephone numbers are usually stored
as a char type
HTH
Peter
> -Original Message-
At 4:59 -0700 10/2/04, Stuart Felenstein wrote:
I have a field "telephone".
Set to type :int:
Length: 11
It's not working correctly, and not sure if it's my
application or something I have wrongly set up for the
database.
We are talking about U.S. Telephone numbers here, so 7
digits (area code, ex
I guess that is why if I enter 703111
I get this back - 4294967295
Stuart
--- GH <[EMAIL PROTECTED]> wrote:
> One issue could be that an int column unsigned can
> only hold up to
> 4294967295 a ten digit number. Plus if you put it in
> a context of a
> phone number... only area codes 428 or
One issue could be that an int column unsigned can only hold up to
4294967295 a ten digit number. Plus if you put it in a context of a
phone number... only area codes 428 or lower will have ALL THE
EXCHANGES and ALL THE UNIQUE NUMBERS in the range... with part of area
code 429
A bigint will hold t
