#86 insert data in text fields in mysql 4.1.1

[Luca Morelli]

i'm using text fields to insert files, even binary, so i can
make full text searches, but i found that some bytes are
stored in a different way: characters 0x96 are stored in
the field as 0x13, 0x86 are stored as 0x20, 0x87 as
0x21, 0x9c as 0x53. if a change the fields from text to
blob all works fine.
i checked with a delphi application using zeosdbo and
the storage of the data is correct.

[Reggie Burnett]

Logged In: YES
user_id=523261

How are you inserting the values? can you send me some
code? The following test code worked ok for me.

string data = "my\x096\x09c\x086\x087 data";
MySqlCommand cmd = new MySqlCommand("INSERT INTO
Test1 VALUES (1, 'Reggie', @blob)", c);
cmd.Parameters.Add( "@blob", data );
cmd.ExecuteNonQuery();

cmd.CommandText = "SELECT * FROM Test1";
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
string outData = reader.GetString(2)
byte[] buf = new byte[100];
long count = reader.GetBytes( 2, 0, buf, 0, 7 );

the buf array that is returned is ok as is the string that is
returned.