C# Entity Framework Migrations adding weird characters to string

Question

I have strings in my MsSql database with nvarchar column type. My seed method sample is this:

protected override void Seed(Sro.Models.ApplicationDbContext db)
    {
        Konu iyimi = new Konu { isim ="ıyımıdır", lastAktifTime = DateTime.Now, konuUrl = "iyimi", };
        db.Konu.AddOrUpdate(iyimi);
    }

when I execute the seed method some characters "ç, ö" are okay but "ı" character saving as "ý" in database, for example "ıyımıdır" appears "ýyýmýdýr". I tried differen sql servers but the result is same. By the way there's no problem with website queries. When I try to add new row when debugging it is okay. It doesn't make any sense to me. Thanks for any help.

for some reason it was converted to ANSII or something else. I changed file encoding with Notepad++ now it works. — Okan Aslankan
– Okan Aslankan, Commented Sep 26, 2015 at 22:38

Community · Accepted Answer · 2017-05-23 11:51:29Z

1

Add "Charset=utf8" to entity connection string.

Entity Framework C# Insert Data russian encoding problems

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Sep 26, 2015 at 19:00

umut özkan

1321 silver badge8 bronze badges

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

Comments

Szynkie · Accepted Answer · 2022-01-12 14:04:25Z

0

Try add 'N' before string eg: UPDATE TableName SET Name = N'śćżas' WHERE Id = 0

answered Jan 12, 2022 at 14:04

Szynkie

891 silver badge5 bronze badges

1 Comment

Serge P Over a year ago

This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review

Collectives™ on Stack Overflow

C# Entity Framework Migrations adding weird characters to string

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related