Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bhaskar27in
Starting Member
1 Post |
 Posted - 2012-11-20 : 01:28:01
|
| 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 |
|
|
|
|
|
Character Encoding - Conversion