How to read a string with UTF8 coding using linq to entities

Question

I am trying to read a LimeSurvey table using Linq to entities. My problem is that LimeSurvey stores strings in UTF8 and .Net doesn't like it...

So, i've got a simple function to list all my surveys, how can i tell Linq to read the strings in UTF8 format?

My function:

public static List<Lime_Surveys> List()
    {
        using (LimeSurveyEntities db = new LimeSurveyEntities())
        {

            IQueryable<Lime_Surveys> list = db.Lime_Surveys.Include("Lime_Surveys_LanguageSettings");

            return list.ToList();
        }
    }

@Henk Holterman: the table Lime_Surveys has several string fields, all with the same issue... every time a character like 'é' is used the string is displayed wrong on .net — Sergio
– Sergio, Commented Dec 6, 2011 at 23:32
'wrong' is not much of a problem report. If you want answers: samples, details, hex-views. — Henk Holterman
– Henk Holterman, Commented Dec 7, 2011 at 0:31
@Henk Holterman: I think the problem is explicit. I have a string in a database stored from a php program in utf8, characters like éãçí etc are replaced by symbols. on read, php displays them ok, .Net displays them exactly how their stored in the database. I know it's utf8 because notepad++ displays the string correctly when using that option. — Sergio
– Sergio, Commented Dec 7, 2011 at 9:51
@okrumnow: Thanks, that worked perfectly. If you place if as an answer i'll upvote & mark it as accepted. — Sergio
– Sergio, Commented Dec 7, 2011 at 10:36

Community · Accepted Answer · 2017-05-23 12:22:43Z

6

You need to change the encoding of the string you read using

Encoding.UTF8.GetString(Encoding.Default.GetBytes(yourstring))

Check out this answer: Get correct output from UTF-8 stored in VarChar using Entity Framework or Linq2SQL?

edited May 23, 2017 at 12:22

CommunityBot

11 silver badge

answered Dec 7, 2011 at 12:56

okrumnow

2,4261 gold badge25 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read a string with UTF8 coding using linq to entities

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related