From: Karima Velasquez
Date: August 15 2005 6:48pm
Subject: character encoding
List-Archive: http://lists.mysql.com/mysql/187831
Message-Id: <b8d2acd80508151148695d5c4a@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_868_33342070.1124131733259"

------=_Part_868_33342070.1124131733259
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

hello...

i'm having some troubles storing data in mysql and thought you can help,=20
here is my problem:

i'm capturing raw audio/video data and want to store it into mysql. in my=
=20
c++ program i create the query to do this, i use sprintf to create this=20
query using %s format for the printing.

using PTRACE, i print the query and the data is ok. but, when i connect to=
=20
the database, the data is wrong. i know this because i create a wav file at=
=20
the same time that the data is inserted in the database; i can play this wa=
v=20
file, it is ok. the data in the wav file and the data in the database does=
=20
not match!

i've been reading about the character set/collate in mysql, but don=B4t kno=
w=20
which one should i use. does anybody know?

thanks for any reply...

best regards,
karima

------=_Part_868_33342070.1124131733259--