Thanks @Thom, @Siggemannen for your insights.

I tried in my environment by saving the .csv file in UTF-8 format and import the data into Azure SQL DB and it works well by saving the data in the same format into my Azure SQL Database successfully as shown in the below output.

I tried to save the below .csv data with UTF-8 format into Azure SQL DB.

Id,Description
1,"Price is £100"

Output: