Blob field returns the same value for all rows

[Thomas Linde]

Hello.

I'm working with a webbased translation module written in ASP.NET for my application. Its handling 22 languages. My problem is that the ISP I'm using is running MySQL 4.0.16 which doesn't support unicode at all. So a BLOB field is nice since I could then store the binary data of the strings instead (I don't care about sorting) and then read the byte stream back with a encoder in .NET.

However, when querying the database and returning a datatable the BLOB field contains the same data in every row. A closer look tells me that all rows contains the exact same Byte data as the last row.

I'm using the latest beta of the mysql.NET connector.

Any information regarding this?

Regards
//Thomas Linde