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 or database designation not allow to you change the mode of Unicode. There is other way to do is that insert the Unicode forcibly by using prefix ‘N’ when storing data into database.

Add prefix ‘N’ when using queries
Using prefix ‘N’ when using store procedure

And after these done, you need to retrieve the data from database and decode it by Unicode mode. Then the system will display Unicode in your application.

Leave a comment