Jump to content


Photo

Table and money


  • Please log in to reply
3 replies to this topic

#1 smith.james0

smith.james0
  • Members
  • PipPipPip
  • Advanced Member
  • 122 posts

Posted 30 January 2006 - 09:02 PM

I have a column (varchar) full of values of money. I need to put the in order of value but it doesn't work with type set to varchar, what type do i need? Can some help.

Thanks James

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 30 January 2006 - 09:06 PM

float
Legend has it that reading the manual never killed anyone.
My site

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 31 January 2006 - 12:11 AM

I belive that the DECIMAL column type will be best suited for this task, for obvious reasons.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#4 smith.james0

smith.james0
  • Members
  • PipPipPip
  • Advanced Member
  • 122 posts

Posted 31 January 2006 - 07:41 PM

Thanks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users