problem with ip address insertion

mysql problem

[neiljones]

This problem is manifesting it self outside PHP at the level of directly typing commands into the MYSQL application itself. Obviously it is going to have the same effect inside PHP. I need escape characters or something but nothing I have tried works.

typing the command
INSERT INTO table(ip,commentfield)VALUES ("111.222.333", 'old spammer
');

results in only the characters 111 appearing in the ip field . It is defined as a char 16 field.

[edited by: jatar_k at 8:52 pm (utc) on Feb. 13, 2004]
[edit reason] generalized [/edit]

[jatar_k]

what about single quotes

INSERT INTO table(ip,commentfield)VALUES ('111.222.333', 'old spammer');

[neiljones]

I tried that first of all. It has the same effect.

[justageek]

I use a varchar(15) and insert with quotes and have no problems. Try that.

JAG