Do yourself a favor run an alter table and change the column to a char or varchar.
I hope this helps...
Pat...
[EMAIL PROTECTED] CocoNet Corporation 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 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 the complete range you are looking for.... However, I would sugest that since you mostlikely are not going to be doing mathematical operations on a phone number that you use a varchar or char field.
Maybe someone could correct me but aren't regex for strings only?
Gary
On Sat, 2 Oct 2004 04:59:45 -0700 (PDT), Stuart Felenstein <[EMAIL PROTECTED]> 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, exchange, unique number)
Now it seems everything works up to the storing of 6 numbers. Once I add the 7th number, everything goes haywire. The number gets transformed to some totally different number and / or 0 (zero).
Now I had set up a validation , which I think would be correct for a U.S. number:
[0-9\+\-\/ \(\)\.]+
Yet, even if I remove that regexp and let it validate solely on integers: -{0,1}\d+
Nothing. I thought perhaps enforcing the field to unsigned might help, but no change.
One last note, I've "now" added some javascript to enforce format. This hasn't changed anything , better or worse. Same behaviour. This is solely for making sure client enters 111-111-1111 format. Just wanted to include this in my information.
Well if anyone has a clue appreicate the help.
Stuart
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]