Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Exclamation Unanswered: dataType: Money vs Num

    Based on what I know, there really isn’t much difference between Money data types and Numeric data types. For the purposes of formatting I want to switch a field that had Money, as it’s original data type to Numeric.

    Does anyone know what the major difference is between these two? …and/or have you run into any problems around this type of switch?

    Cheers,

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    If you are going to use datatype money for keeping cost,price,etc. - it is what this datatype for (4 digits after period). If you need more digits after period - money is not your choise.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Another point, is that the money datatype is tied to your local settings on the DB server. If you want to try saving Euros, or Yen, then you may start pulling your hair out.

  4. #4
    Join Date
    Oct 2003
    Posts
    3

    Question

    that's exactly it..the field was originally money but the function was set up for 2 decimals - we needed 4. We changed it and all was fine for a while. It passing the 4 decimals to the ASP pages just fine..then it just stopped for some reason! That's why we switch the datatype to numeric with 4 decimals. That pushed the right data to the ASP pages but is buggering up some of our bolt on apps. We really want to go back to money 4 decimal but we're kinda stumpped here.

    thanks for your help!


    Originally posted by snail
    If you are going to use datatype money for keeping cost,price,etc. - it is what this datatype for (4 digits after period). If you need more digits after period - money is not your choise.

  5. #5
    Join Date
    Oct 2003
    Posts
    3

    Cool

    do you mean the db server's regional OS settings for Money?

    this is great help guys - thanks!

    Originally posted by MCrowley
    Another point, is that the money datatype is tied to your local settings on the DB server. If you want to try saving Euros, or Yen, then you may start pulling your hair out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •