Relative Content

Tag Archive for sql-servertamilsql-server-collation

Restoring database in sql server 2014 leads to junk characters for tamil data

While migrating data from one sql server to the other I have access to just the .BAK file. I tried restoring it in my sql express 2014. While the restore was successful the data inside the tables are now showing some junk characters. When I try to create a new row in the same table in Tamil language as an nvarchar it does insert properly and I am able to view the data in tamil language properly. Just that the rows which were restored are having junk characters. Below is the snippet of the data that has been restored. Can someone let me know what is it that I am missing. Quite new to having data other than English in the database. So not sure if there are any Collation settings that needs to be tweaked in order for the db to support regional language support during a restore.