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

Storing in HEX format.

Hello, I am writing a program for packet sniffing in Linux platform using C language. I am using MYSQL as my database for storing packet information like IP, port, packet payload, etc. I have created a table using the following query: create table idsmatch(sip text,sport integer,dip text,dport