C# Windows Forms SQL database table Cyrillic characters

Question

I created a Windows form application in C# and using a SQL database. I am from Bulgaria and I need cyrillic characters in my database but whet I use cyrillic character they appear in database as '?'.

If anyone can help me I will be very happy because this is my first Windows forms application!

See image -> See image

Are you writing SQL (structured query language) and really mean Microsoft SQL Server (the actual product) by this? If yes: please add sql-server tag to make this clear. If not: what database system is this for? — marc_s
– marc_s, Commented Nov 7, 2013 at 20:32

marc_s · Accepted Answer · 2013-11-07 20:50:39Z

2

To successfully store (and retrieve) Cyrillic characters, you must

use nvarchar(n) datatype in your database table - are you?
when inserting, either use the N' prefix (INSERT INTO YourTable(...) VALUES(N'....', ...) or make sure the calling application (your C# code) also uses and specifies nvarchar (Unicode characters)

answered Nov 7, 2013 at 20:50

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

Collectives™ on Stack Overflow

C# Windows Forms SQL database table Cyrillic characters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related