Hi all,
i am facing a serious problem working with MySQL and Nhibernate named queries.
I have written a stored procedure and i am calling it in C# using a flat class to map the database fields. My problem is it seems to work fine with Mysql 5.1 but not with 5.0

I have a STRING property day_of_week in my class. But when i try to call the stored procedure it throws the following error :

"The type System.Byte[] can not be assigned to a property of type System.String setter of "AssessmentFeedbackReportDTO.DayOfTheWeek" .

It works without any fuss in MySql v 5.1

Any help is much appreciated.
Thanks in advance.

I got The Solution By Using

convert(DAYNAME(Column)USING utf8)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.