Can I change the encoding of SQL? I enter text in Russian, but instead the text is displayed: '???'
Asked
Active
Viewed 43 times
0
-
What is your database collation set to? I believe you want utf8 to handle Russian characters – Asnivor Dec 07 '16 at 17:36
-
SQL_Latin1_General_CP1_CI_AS , yes i need convert to utf8 – J. Defenses Dec 07 '16 at 17:38
-
What is the field type you are trying to write to? varchar? If this is not a production database you could try changing that field to nvarchar and it should handle the Cyrillic (unicode) characters. – Asnivor Dec 07 '16 at 17:42
-
I use NVARCHAR. that's why I thought that it encoded. – J. Defenses Dec 07 '16 at 17:43
-
Can i convert text to utf8 in c# and send it to DB? – J. Defenses Dec 07 '16 at 17:46
-
Take a look at the first answer here: http://stackoverflow.com/questions/12632240/entityframework-update-or-insert-chinese-or-non-english-text - Check that unicode is enabled in the EF field property – Asnivor Dec 07 '16 at 17:49
-
I executed it: Cyrillic_General_CI_AS – J. Defenses Dec 07 '16 at 18:13