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: character encoding

2005-08-16 Thread Karima Velasquez
] wrote: Karima Velasquez wrote: do you know about any sample code on using BLOB columns using c++ to create querys??? C++, eh? I happen to be the MySQL++ maintainer. Two of its example programs, cgi_image and load_file, deal with BLOBs. http://tangentsoft.net/mysql++/ Notice

Re: character encoding

2005-08-16 Thread Karima Velasquez
function should i use? thanks for your replys karima On 8/16/05, Warren Young [EMAIL PROTECTED] wrote: Karima Velasquez wrote: character is: \ (backslash). Of course that will cause problems. This is the escape character in SQL, used extensively when inserting BLOB data. Again, I

character encoding

2005-08-15 Thread Karima Velasquez
hello... i'm having some troubles storing data in mysql and thought you can help, here is my problem: i'm capturing raw audio/video data and want to store it into mysql. in my c++ program i create the query to do this, i use sprintf to create this query using %s format for the printing.

Re: character encoding

2005-08-15 Thread Karima Velasquez
... any toughts? On 8/15/05, Warren Young [EMAIL PROTECTED] wrote: Karima Velasquez wrote: i'm capturing raw audio/video data and want to store it into mysql. in my c++ program i create the query to do this, i use sprintf to create this query using %s format for the printing. Um, you

Re: character encoding

2005-08-15 Thread Karima Velasquez
regards, karima On 8/15/05, Warren Young [EMAIL PROTECTED] wrote: Karima Velasquez wrote: i know about the null terminating character, but i don't think this is the problem. It might not be your immediate problem, but you will run into it eventually. rigth data: 82 wrong data