Problems with encoding ASP.NET Core & SQL Server

Question

I have problems with russian language in my database. I read data from xlsx file. For reading I use library OfficeOpenXml. While debugging there is no problems with encoding, but after adding to database there are only ???. And here is what I've got:

If its colation you can check that on your SQL side by running this query then you need to update it if it is not what you need: SELECT collation_name FROM sys.databases WHERE name = 'database name'; Here is more info: learn.microsoft.com/en-us/sql/relational-databases/collations/… — Brad
– Brad, Commented May 18, 2018 at 19:19
Are your character columns set to unicode (ex: nvarchar(max))? — Jacob H
– Jacob H, Commented May 18, 2018 at 19:39
You need to read about, understand and start using parameterized queries. Your code is wide open to sql injection. You should NEVER EVER EVER build up a string like this and execute it. My friend bobby tables love this kind of code. bobby-tables.com — Sean Lange
– Sean Lange, Commented May 18, 2018 at 19:41

MulderX · Accepted Answer · 2018-05-18 20:23:08Z

1

ensure your datatypes on the string fields are the "n" versions for strings. nChar, nvarchar, nText so that you will not loose data when dealing with nonANSI charsets

https://learn.microsoft.com/en-us/sql/t-sql/data-types/nchar-and-nvarchar-transact-sql?view=sql-server-2017

answered May 18, 2018 at 20:23

MulderX

234 bronze badges

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

Comments

Nastya Scherbakova · Accepted Answer · 2018-05-18 21:04:06Z

1

Solved by changing database collation on Cyrillic_General_CI_AS

answered May 18, 2018 at 21:04

Nastya Scherbakova

1721 gold badge2 silver badges10 bronze badges

Collectives™ on Stack Overflow

Problems with encoding ASP.NET Core & SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related