SQL Server Database Collation Issue

The SQL Server is used for storing data like employment details, salary slips, Lectures notes, many other things. But sometimes due to collation issues the user is unable to read the content stored on the SQL Server. The text appears like Ã, Ã, ¢, â, and it becomes a difficult task for the user to decode it. This happens because a corresponding character appears over the original data.

The reasons for SQL Server Collation are:-

• Installing a New Instance of SQL Server.
• Restoring data from the Database Backup.
• Connecting SQL Server to the Client Databases.

Whatever may be the reason but ultimately the user can not read the information which he has stored on the SQL Server. The only way left is to repair the MDF files of the SQL Server in which the information are stored.

Let’s Discuss a Real incidence which took place with the HR Manager.

“I am the HR Manager of a finance company located in California and I always used to keep the attendance sheets of the employees on the SQL Server. The day before yesterday I had to submit the sheet to the finance department so that they can sanction the salary to the employees but unfortunately I was unable to read any of the employee’s name and attendance. I am not able to describe how the content appears to me but I would like to share a screenshot of that sheet. I hope you’ll understand my problem better once you see the image. Please help me out because I have got the extension of only three days.”

Screenshot Sent by the HR Manager

Solution

The only way out to this problem is to try SQL Server Management Studio because the manual methods will take a lot of time and the final results may also vary. The manual method doesn’t give the guarantee that it recovers all the data but with the help of SQL Server Management Studio, the user can repair all his data.

Fix Invalid form of Text in SQL Server

• Download and Install SQL Server Management Studio on the PC.
• Enter the Server Name and Select Server Type as Database Engine.
  
• After Connecting to the Server Click on Collation option.
  
• Under Database Engine Click on Customize Button.
  
• Now the Output wizard opens and the user can see the Collation Type.
  
• Select the option SQL Collation Used for Backward Compatibility option.
  
• Click on SQL_1xCompat_CP850_CI_AS and then on OK Button.
  

After the Completion of the whole process, the user will be able to read the invalid content and all his content would be rectified.

Conclusion

I hope the whole case is transparent to you and you have understood the scenario.
It is a real case of one of our customer and she has appreciated our work. If you have stuck in the same situation then feel free to contact us. Out technical team will address your issues as soon as possible.