PHP/mySQL dropping zeros on INSERT INTO

[Rottingham]

Hello

 

I'm performing a standard insert:

 

$account = "D347660";

INSERT INTO "table" SET Account='$account'

 

Every insert drops that trailing zero at the end of the account number! How can I make it stop doing that???

[de.monkeyz]

If Account is a varchar field, check the maximum length of the field, if it's longer than that string that's why, since I see no other reason for it to be removed.

[Rottingham]

I've done that. It's a 7 digit number and I set max characters to 7. When I noticed this problem I bumped it up to 8 and it still does that.

[de.monkeyz]

What happens when you echo out your query in php? Is the trailing 0 still there?

 

And is the datatype of the database a number, or VARCHAR?

[Rottingham]

Yes the zero stays on my echo output. Only drops on the SQL insert.

 

It is VARCHAR(.

 

I'm baffled. I've faced this before I think but can't remember the best solution. I can make the field an INT and it won't do that but I lose my character at the front.

[de.monkeyz]

If it's mySQL you should check your database table. Try to manually enter the data in something like phpMyAdmin, it should give you a more verbose output if anything is going wrong.

[laPistola]

is the character the same on all account numbers??

[Rottingham]

Ok so I figured it out...

 

Another stupid error like most are.

 

There was a sneaky whitespace at the beginning of the string.

 

a simple trim() fixed it...

[de.monkeyz]

Good ol' whitespace. Gotta love it, the cause of 100% of invisible errors.

[laPistola]

Haha i have been hit by that one tonight as well!