Issue with uploading Patient Data having special characters

While uploading Patient Information such as (Registration Number,Registration Date,First Name,Middle Name,Last Name,Gender,Birth Date,Address. Province,Address.Neighbourhood,Address.Street) Data CSV ,which contains special character in different fields are not showing up as expected.

Findings: 1.If i upload the data with .CSV format then its successfully uploaded but special characters are not showing up properly.

2.After uploading the address data i am able to change the entries manually from UI but incase of bulk upload it is very difficult to change everything manually.

3.If we add patient name with special character then its throwing error.

4.If i changed the format to UTF-8 CSV then its not able to upload CSV , throwing error "No Column found in the csv file. Registration Number”