Storing Greek | Polish | Cyrillic (Russian) Alphabet in Database

When saving cryillic alphabet or other languages which do not use the english alphabet, the datatypes text and varchar do not support the alphabet symbols.

It usually turns all text into ??????

For instance I had tested saving “Интернет-программирование ” into a column with datatype text and it saved all as ” ???????- ? ???? ???”.

In order for this not to happen we simply save the column with the datatype nvarchar(MAX) since nvarchar supports a vast range of symbols which other datatypes do not. The only disadvantage of such datatype will be that it takes some more space than other datatypes.

PS. To send Such alphabets in an email it is required to first add the following:

MailMessage mm = new MailMessage(“EmailAddress”, “EmailAddess”);

mm.IsBodyHtml = true;
mm.SubjectEncoding = System.Text.Encoding.UTF8;
mm.BodyEncoding = System.Text.Encoding.UTF8;