[RESOLVED] trying to enter number into phpMySQL

This site is best viewed in a modern browser with JavaScript enabled.

[RESOLVED] trying to enter number into phpMySQL

tuxandpucks

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

Nomistake

just plain varchar?

NogDog

Yeah, 0.1.1 is not a number, it's a character string.

tuxandpucks

Thank you. Just plain VARCHAR worked.