How to search in Arabic in ASPX page in SQL2012 where arabic text is stored?

See more:

C#

ASP.NET

SQL

I need to write a simple page (ASPX) where I can do the search on Arabic text.
SQL 2012 as Database - EntityFramework - ASPX web form

The SQL database will contain only 2-3 tables. Since English and Arabic is fixed language (no more other languages) I plan to create both language in 1 table (no Language column to filter)...

The ASPX (Webform) page will show only English or Arabic (hyperlink to switch Lang).

I created a Database and Collation = Arabic_CI_AI => I hope this is ok.

then I've there a table e.g. tblBook. This will contain books in Arabic text and English text.
e.g.
tblBook
==========
Id 1
BookTitleEN My first book
BookTitleAR مرحبا الكتاب
DescriptionEN Family Barbara
DescriptionAR وصف هذا الكتاب
AuthorEN Mr. Michael
AuthorAR السيد مايكل
etc.

Ok above you see a sample table layout and sample values... I've never written Arabic Text and don't have experience Arabic and can't read/write... just copy/paste from web some text.

Can someone guide me for the tips I need to pay attention? Because the client told me that he wants to search on partial Arabic Text... so e.g. AuthorAR like '% مايكل %'- So please advice me will this work or where do I need to pay attention....
- is the collaction Arabic_CI_AI fine?
- What else?????