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
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...