mysql_hex_string()

2005-08-18 Thread Karima Velasquez
hi everyone... i need to store binary data (corresponding to audio and video) into mysql. i'm using a longblob field. i already used the mysql_real_query() and mysql_real_escape_string(), but had no luck... :( my next idea is to try mysql_hex_string() to store the data in hex format. my

Re: mysql_hex_string()

2005-08-18 Thread Paul DuBois
mysql_hex_string() to store the data in hex format. my question is: after the data is encoded in hex by mysql_hex_string(), how is it returned to its original format? The server decodes the hex value when it executes the statement. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB

mysql_hex_string() c-api

2005-08-16 Thread Danny Stolle
Hello all, can somebody explain to me the c-api mysql_hex_string(). when i debug my example in DDD i get the full sql-dml (insert) as a hex-value; which this function returns. putting a 0x in front of the hex and use it in a mysql_real_query() returns an error. or am i doing it wrong! should

Re: mysql_hex_string() c-api

2005-08-16 Thread Paul DuBois
At 19:43 +0200 8/16/05, Danny Stolle wrote: Hello all, can somebody explain to me the c-api mysql_hex_string(). when i debug my example in DDD i get the full sql-dml (insert) as a hex-value; which this function returns. putting a 0x in front of the hex and use it in a mysql_real_query

Re: mysql_hex_string() c-api

2005-08-16 Thread Danny Stolle
I thought it was something like that ... I just found it strange allready. I'll give it a try, thanx. Danny Paul DuBois wrote: At 19:43 +0200 8/16/05, Danny Stolle wrote: Hello all, can somebody explain to me the c-api mysql_hex_string(). when i debug my example in DDD i get the full sql