Blob field returns the same value for all rows
Posted by: Thomas Linde
Date: November 15, 2004 04:47PM


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?

//Thomas Linde

Options: ReplyQuote

Written By
Blob field returns the same value for all rows
November 15, 2004 04:47PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.