Results 1 to 2 of 2

Thread: Any way to make MYSQL do NOT remove nulls at the end of number?

  1. #1
    Join Date
    Oct 2007
    Posts
    37
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Any way to make MYSQL do NOT remove nulls at the end of number?

    Is that possible?
    I mean is it possible to hold in db numbers like 6.780 or 0.30 or 9.00?
    Thanks in advance!

  2. #2
    Join Date
    Feb 2008
    Location
    Coventry
    Posts
    103
    Thanks
    5
    Thanked 8 Times in 8 Posts

    Default

    Would it be best to use the field type in your database as a decimal???
    I presume your just using it as a flat Int or Double?

    I suggest changing it to decimal to see what happens. Do a test table and see how it fares if you insert into it.

    Dont know anything else i could suggest, unless someone else has an idea?

    Hope its helped

  3. The Following User Says Thank You to city_coder For This Useful Post:

    Samuell (03-11-2008)

Bookmarks

Posting Permissions

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