Posted - 11/20/2012 : 01:28:01
We have a CRM application which records the emails into a database. The Database uses the Collation: SQL_Latin1_General_CP1_CI_AS.
When I query this table to retrieve the subjects of the email using say a fromaddress, it gives the following results for texts in non english languages:
I would like to know why is the data being stored in such a way and is there a way to convert them back to original text using queries?
Please note that I cannot modify any contents of this Database as that is the Enterprise DB and I have no control over it.
Any help/suggestions will be highly appreciated.