Character Data Corruption in SQL Server and MDF Recovery

While interacting with MDF file of MS SQL Server, consider the given scenarios:

In MS SQL Server, you use SSMS (SQL Server Management Studio) to query character data from the SQL Server database which uses a non-Unicode data type. For instance, the SQL Server uses the char, varchar or the text data type.

The code page of client computer differs form code page of database.

In such circumstances, the character data may be represented incorrectly. For instance, you may face any of the subsequent issues:

The characters are represented as the question mark. You might come across this issue if you have inserted or updated character data as non-Unicode data type prior to querying character data. sql recovery--
Telemarketing Services--Audience Response Systems--KVM Switches--

Read full article from here : http://www.americanchronicle.com/articles/72803