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. using PTRACE, i print the query and the data is ok. but, when i connect to the database, the data is wrong. i know this because i create a wav file at the same time that the data is inserted in the database; i can play this wav file, it is ok. the data in the wav file and the data in the database does not match! i've been reading about the character set/collate in mysql, but don´t know which one should i use. does anybody know? thanks for any reply... best regards, karima
