Database Forum
Web Database Register Members List Calendar FAQ

 
Go Back   Database Forum > PHPMagic Discussions > General questions
User Name
Password

Reply
 
Thread Tools Search this Thread Display Modes
Default Field Changes Automatically
01-07-2009, 11:46 AM #1  

mwalkerbcc
Junior Member

 
Status: Offline
Posts: 9
Join Date: Jan 2009

I have a integer field set up for phone numbers, length 10. When I save it to a record the number changes!?? Anyone know why?
Reply With Quote

Default
01-07-2009, 02:57 PM #2  

clifford
Senior Member

 
Status: Offline
Posts: 266
Join Date: Mar 2005
Location: San Fran, CA

Changes to what?
Reply With Quote

Default Field Changes
01-07-2009, 03:19 PM #3  

mwalkerbcc
Junior Member

 
Status: Offline
Posts: 9
Join Date: Jan 2009

Strangely enough when I have added two different phone numbers to the field on both occassions it displayed this number "2147483647" when I added as new.
Reply With Quote

Default
01-07-2009, 05:54 PM #4  

xacto
Senior Member

 
Status: Offline
Posts: 159
Join Date: Mar 2005
Location: Miami, Florida

If the field is for phone numbers you should use VarChar. If an INT column is UNSIGNED, the size of the column's range is the same but its endpoints shift from -2147483648 and 2147483647 more....
Reply With Quote

Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT -5. The time now is 01:39 AM.

Powered by: vBulletin Version 3.7.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Database Forums

Help support our forum assistants and product development ->

go to top go to top