Re: Storing in HEX format.

[EMAIL PROTECTED] wrote: Uh-oh ;-) I think you put the HEX in the wrong part. Shouldn't it be in the VALUES clause? snprintf(query_length,query,"INSERT INTO idsmatch(sip,sport,dip,dport,payload) VALUES('%s',%d,'%s',%d,HEX('%s'))", inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,t

Re: Storing in HEX format.

Uh-oh ;-) I think you put the HEX in the wrong part. Shouldn't it be in the VALUES clause? snprintf(query_length,query,"INSERT INTO idsmatch(sip,sport,dip,dport,payload) VALUES('%s',%d,'%s',%d,HEX('%s'))", inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp); Shawn Green Database A

Re: Storing in HEX format.

Hi, snprintf(query_length,query, "INSERT INTO idsmatch(sip,sport,dip,dport,HEX(payload))VALUES('%s',%d,'%s',%d,'%s')", inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp); -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.m