Back To Programming / Scripting / Coding Forum

SQL table Lenth Values

  • DavyDuke17
  • Graduate
  • Graduate
  • No Avatar
  • Joined: Dec 20, 2003
  • Posts: 166
  • Status: Offline

Post January 11th, 2004, 5:15 pm

I want numbers like .333 for a certain field in a sql table. I thought that using decimal with the length of 3 would do allow me to do it but when I enter data it goes to 1. What should I use?
Baseball-Now
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post January 11th, 2004, 5:15 pm

  • b_heyer
  • Web Master
  • Web Master
  • User avatar
  • Joined: Jun 15, 2003
  • Posts: 4583
  • Loc: Maryland
  • Status: Offline

Post January 11th, 2004, 5:45 pm

A length of four. Each character counts.
Pixel Acres V2
  • Lieven
  • Beginner
  • Beginner
  • User avatar
  • Joined: Jan 04, 2004
  • Posts: 57
  • Loc: Belgium
  • Status: Offline

Post January 16th, 2004, 6:51 am

If you're using MySQL, you should have DECIMAL(4,3)

Page 1 of 1

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 147 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.