Solution of Unicode issue with non-Unicode SQL server design

Background: If database setting can be changed then everything will be fine. Just changing database setting to Unicode mode by Clicking Database Properties-> Options ->Collation and choose the unicode option that you want like followings: But if this can not be done for somewhat reason like the the database is existing one without permission available […]