How to save unicode in database using entity framework.

Question

0.00/5 (No votes)

See more:

I need to save Unicode(Korean text) in my database column using entity framework with database first approach. but it save '???' question marks instead of unicode text. can someone suggest me the solution.

What I have tried:

I change database table column datatype varchar(100) to 'nvarchar(max)'. i also use add

[Column(TypeName = "nvarchar(500)")]

in modal property for that perticular column. but it is also not working.

Posted 21-Mar-21 23:00pm

TCS54321

Add a Solution

Comments

Maciej Los 22-Mar-21 5:53am

What is Collation in Databases? | Database.Guide[^]
You should use utf-8.

TCS54321 22-Mar-21 5:56am

i also try this.. but it's not working.
alter table MyTable
alter column MyColumn nvarchar(max) COLLATE Korean_90_CI_AI

Maciej Los 22-Mar-21 6:11am

Not a column! Entire database!

Richard Deeming 23-Mar-21 5:13am

Collations shouldn't have any impact on storing data in an nvarchar column. :)

[no name] 22-Mar-21 13:25pm

I would start by "reading" from a table that you have loaded with Korean text. You're making a lot of assumptions based on very little information. Maybe you're looking at it with the wrong font for that matter.

Richard Deeming 23-Mar-21 5:16am

Check the actual data type of your database column. Run a SELECT query in SQL Server Management Studio to see what the data really looks like in the database.

If the data in the database is invalid, debug your code and step through it from the point the text is entered. It's possible that the encoding problems are happening before the text gets to Entity Framework.

If the data in the database looks good, then it's a problem with how you're retrieving and displaying the data. Again, you will need to debug your code to see where the encoding problems are occurring.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)