All data has been changed to gobbledygook in my DB

Hello

I got a serious problem about my data in SQL 2005. I save data in SQL in Farsi, this is not English so. Up to now everything was going well.

But today, surprisingly, I found out all my data in database has been changed to some gobbledygook like these: ù??§ù??§????or?3?±???1 ?±?§ù? ?±ù??aù?

Although all data which I saved yesterday are correct, all the data for the past days has been changed to meaningless ones.

Anybody knows why n how to repair?

All responses appreciated.

Refer to the SQL 2005 books online for UNICODE data and ensure collation has been set to correct values.|||Hello
Thank you for your response
I told you that some of my data has been changed to meaningless data, while some data has not been touched. however I tested your suggestion but that was not successful.
any idea?
Thanks|||

If you are confident that you have not modified the data, and that the client is displaying the data in the proper code page..

Start by running DBCC CHECKDB if there is any damage in the database this should pick it up.

|||In The Name of God
hi,
Special thnaks for your response,
I restored my db from the backups which I had taken earlier and I had forgotten that I had them, but,
could you please tell me what kind of errors this statement can retrive(DBCC CHECKDB)?
Thanks
|||

DBCC CHECKDB can determine a variety of problems, ranging from damage to the files themselves to data purity issues.

The DBCC CHECKDB topic in Books online is a great reference.