SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Character Encoding - Conversion
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

bhaskar27in
Starting Member

India
1 Posts

Posted - 11/20/2012 :  01:28:01  Show Profile  Reply with Quote
Hi,

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:

1. =?ks_c_5601-1987?B?us/H0bvqwLogvvPAvbLJIMDcxKEgwd8uLi6x4sL3xbiw7SA=?=

2. =?big5?B?Pz8/PyA/Pz8gPz8gPy4uLj8/Pz8=?=

3. =?koi8-r?B?VGVzdCBLb3JlYW4tID8/ID8/Pw==?=

4. =?utf-8?B?Rlc6IEZ3Oui9rOWPkTogUkU6IOi9rOWPkTog5be06buO5a6c5b+F5oCd5LiJ5pmaIEliaXMgQmFzdGlsbGUgRmF1Ym91cmcgU3QgQW50b2luZQ==?=

5. =?gbk?B?UkU6IM7S0OjSqtK7uPbB2cqxw9zC6w==?=

6. =?gb2312?B?UkU6IM7S0OjSqtK7uPbB2cqxw9zC6w==?=

7. =?euc-kr?B?dGVzdC2/wrXwuMe15SBEQiC79bfOILnetMIguea5/Q==?=

etc...

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.

Thanks,

-Bhaskar
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000