dcsimg
www.webdeveloper.com
Results 1 to 4 of 4

Thread: [RESOLVED] trying to enter number into phpMySQL

  1. #1
    Join Date
    Mar 2011
    Posts
    67

    resolved [RESOLVED] trying to enter number into phpMySQL

    Hi Everyone,

    I am trying to enter 0.1.1 into phpMySQL and I keep getting the 1265 error that my information has been truncated. And, it has. Each time the number shows up as 0.1

    I have tried decimal, float and I am stuck.

    Any ideas?

    Thanks,
    Randy

  2. #2
    Join Date
    Aug 2012
    Posts
    43
    just plain varchar?
    When the only tool you have is a hammer, everything looks like a nail.

  3. #3
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    21,432
    Yeah, 0.1.1 is not a number, it's a character string.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  4. #4
    Join Date
    Mar 2011
    Posts
    67
    Thank you. Just plain VARCHAR worked.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles