Negative value in a table

Taylor_1978 · 01-20-2005, 01:29 AM

Hiya,

I am trying to enter a value in a field set to INT(11), but it will not allow negative numbers. What should this field be to allow such a value?

Thanks in advance!

Taylor.

dniwebdesign · 01-20-2005, 02:13 AM

varchar should be able to hold the value... then when you retrieve it just do a simple math problem to verify you want it an integer.

Example PHP:

PHP Code:


			
$negativevalue=$row["column"];



$value=$negativevalue*1;



//Do whatever you want with the negative $value

I believe this should do what you want.

Kiwi · 01-20-2005, 03:51 AM

Alternatively, you could check the variable definition. It's likely to be defined as UNSIGNED. Note that mySql automatically adds the unsigned property to any field set to ZEROFILL: zerofill is really designed for index columns (keys and foreign keys), where a negative number doesn't make any sense

Putting numberical values in a char field is both wasteful and inefficient.

If all else fails, you might want to take a look through the manual.

01-20-2005, 01:29 AM	PM User \| #1
Taylor_1978 Regular Coder Join Date: Jun 2003 Location: Australia Posts: 506 Thanks: 6 Thanked 7 Times in 7 Posts	Negative value in a table Hiya, I am trying to enter a value in a field set to INT(11), but it will not allow negative numbers. What should this field be to allow such a value? Thanks in advance! Taylor.

01-20-2005, 02:13 AM	PM User \| #2
dniwebdesign Regular Coder Join Date: Dec 2003 Location: Carrot River, Saskatchewan Posts: 677 Thanks: 3 Thanked 2 Times in 2 Posts	varchar should be able to hold the value... then when you retrieve it just do a simple math problem to verify you want it an integer. Example PHP: PHP Code: `$negativevalue=$row["column"]; $value=$negativevalue*1; //Do whatever you want with the negative $value` I believe this should do what you want. __________________ Dawson Irvine CEO - DNI Web Design http://www.dniwebdesign.com

01-20-2005, 03:51 AM	PM User \| #3
Kiwi Regular Coder Join Date: Oct 2002 Posts: 379 Thanks: 0 Thanked 0 Times in 0 Posts	Alternatively, you could check the variable definition. It's likely to be defined as UNSIGNED. Note that mySql automatically adds the unsigned property to any field set to ZEROFILL: zerofill is really designed for index columns (keys and foreign keys), where a negative number doesn't make any sense Putting numberical values in a char field is both wasteful and inefficient. If all else fails, you might want to take a look through the manual. __________________ Strategy Conscious

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread: