Entity Framework C# Insert Data russian encoding problems

Question

I'm using an EDM model in my project.

When I insert russian words in the database via a post request I get ??????

Controller:

[Authorize]
[HttpPost]
public string DescEdit(FormCollection formValues)
{
    var CurrentUserPhoto = User.Identity.Name;
    string x = Request.Form["id"];
    Int64 id = Convert.ToInt64(x);
    photos upPhotoDesc = photosRepository.GetPhotosById(id, CurrentUserPhoto);
    upPhotoDesc.description = Request.Form["value"];
    photosRepository.Save();

    return Request.Form["value"];
}

In the database all charset are set to utf-8
In the layout page content enc type is utf-8

Database code:

CREATE TABLE `photos` (
  `id` bigint(255) NOT NULL AUTO_INCREMENT,
  `done` tinyint(1) NOT NULL DEFAULT '0',
  `imgsmall` varchar(255) NOT NULL DEFAULT '',
  `imgcrop` varchar(255) NOT NULL DEFAULT '',
  `imgmiddle` varchar(255) NOT NULL DEFAULT '',
  `imgbig` varchar(255) NOT NULL DEFAULT '',
  `full_size` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `permission` tinyint(1) NOT NULL DEFAULT '0',
  `userid` int(11) NOT NULL DEFAULT '0',
  `userlogin` varchar(255) NOT NULL DEFAULT '',
  `rating` smallint(5) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `indx_photos_1` (`id`,`userlogin`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci;

Well, something in the chain of events must be doing a lossy conversion to/from an obsolete character set. You will need to identify that something and make sure that it uses Unicode. — Timwi
– Timwi, Commented May 4, 2011 at 20:32
Shot in the dark: Are you sure the database actually contains question marks? Maybe only the thing you’re using to look at the database displays question marks. — Timwi
– Timwi, Commented May 4, 2011 at 20:32
i'm trying to understant where is this "something" for 2 hours already :)) — Evgeniy Labunskiy
– Evgeniy Labunskiy, Commented May 4, 2011 at 20:33
Have you stepped through the code with the debugger and made sure that Request.Form["value"] still contains the correct Cyrillic? — Timwi
– Timwi, Commented May 4, 2011 at 20:36
If you've not seen it already I wrote this article recently on common characterset problems in PHP/LAMP webmonkeyuk.wordpress.com/2011/04/23/… — James C
– James C, Commented May 4, 2011 at 21:22

Massimiliano Kraus · Accepted Answer · 2017-08-09 14:50:01Z

24

Add charset=utf8 to the connection string of Entity Framework
Here is a working add node:

<add name="photostorageEntities"
     connectionString="metadata=res://*/Models.Photos.csdl|res://*/Models.Photos.ssdl|res://*/Models.Photos.msl;provider=MySql.Data.MySqlClient;provider connection string=&quot;server=ServerIP;User Id=UID;password=PASS;Persist Security Info=True;database=photostorage; Charset=utf8&quot;"
     providerName="System.Data.EntityClient" />

edited Aug 9, 2017 at 14:50

Massimiliano Kraus

3,8925 gold badges32 silver badges51 bronze badges

answered May 5, 2011 at 6:57

Evgeniy Labunskiy

2,0424 gold badges27 silver badges45 bronze badges

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

1 Comment

Manu Mohan Over a year ago

adding charset=utf8 causing "nested transactions are not supported" error :(

Collectives™ on Stack Overflow

Entity Framework C# Insert Data russian encoding problems

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related