EntityFramework update or insert Chinese or non-English text

Question

Actually before i did not use framework or linq, just type in sql statement with Sqlcommand class, i type in insert into table values(N'sample') actually i donot know what is N, but it works for Chinese and other Language, otherwise, it will insert some question mark.

But when i use EntityFramework,this kind of framework always insert some question mark, can i ask how to tackle the issue.

N means Unicode? Can you give me one example that EntityFramework use that sort of thing?

BTW, I tested EF with Hebrew in it works just fine. Does Chinese included in the unicode? — gdoron is supporting Monica, Sep 28 '12 at 02:16
It may depend on how the database looks like. If you are using SQL Server - are your columns nvarchar or nchar? In EF the string property needs to have Unicode set to true. Are you using CodeFirst or Database/Model first? — Pawel, Sep 28 '12 at 03:39
You need to provide more information about your mapping and database. — Ladislav Mrnka, Sep 28 '12 at 09:54

score 5 · Answer 1 · answered Jul 15 '14 at 18:42

5

in .edmx Table, select column -> check its properties and set unicode to true
re-generate table if you are working in Code First Apporach
check your database table, it should be nvarchar or ntext datatype

this way EF will save unicode characters.

enter image description here

answered Jul 15 '14 at 18:42

Saboor Awan

1,537
4
24
36

this solved my problem... from "????" text to real working strings Thanks – OldTrain Nov 12 '16 at 20:56

score 2 · Answer 2 · answered Oct 14 '16 at 16:21

2

I had exact same problem for Nepali Language. I had to convert the datatype of sql server column from varchar to nvarchar and then refresh my *.edmx file in entity framework mapping. Then it worked fine.

varchar(255) => nvarchar(255)

varchar(MAX) => nvarchar(MAX)

Right click on that table mapping in edmx file and refresh. Save the changes.

answered Oct 14 '16 at 16:21

merazuu

3,948
6
17
19

This works for me, I changed type from varchar to nvarchar and updated the entity. – Muhammad Bilal Jul 22 '20 at 10:48

score 0 · Answer 3 · answered Oct 10 '12 at 14:22

0

Make sure you have the language packs installed on the server that holds sqlserver for Chinese.

answered Oct 10 '12 at 14:22

DRobertE

3,388
3
24
43

score 0 · Answer 4 · answered Aug 26 '15 at 11:39

0

we just changed the datatype to nchar() or nvarchar and it worked. It was able to store the data in any language other then English.

answered Aug 26 '15 at 11:39

Sarun Kumar

1

EntityFramework update or insert Chinese or non-English text

4 Answers4

Linked