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;

PayPal Direct Payment for C# developers

PayPal integration allows ASP.NET developers to create a Payment Data Transfer (PDT) via PayPal API express checkout to allow direct payments. PayPal Sandbox is a test account which will allow developers to test such API in order to avoid actual payments and transaction fees or interests. Continue reading